Hi,
I'm running queries with MySql 4.0.17 that return thousands of
records. Because I need to present them in GUI, I returieve the
results in chunks using LIMIT, for example - get first 100, then the
range 100-2000 and so on.
The problem is as follows: in the first chunk, MySQL uses one strategy
to fetch the results, and in the following chunks - a different
strategy.
This means that records from the subsequent queries might have records
that already appeared in the first query or that some records will be
left out.
For performance issues it is a problem to add a unique secondary
sorting criteria (like id) to the query.
Is there a clean way to force MySQL to relate to the first (initial)
query result set?
Thanks,
Guy