In the last episode (May 20), Axel Rauschmayer said:
> If I do a follow-up query
>
> SELECT item_id FROM book_catalog WHERE changed > 315529200000 limit \
> 4000,4000
>
> the missing records still do not appear (this table has a total of 5377
> records). Even worse, the first LIMIT query ends with:
>
> 4001
> 4002
> 4003
> 4004
>
> The second LIMIT query starts with:
>
> 4001
> 4002
> 4003
> 4004
Again, what are the reults of an EXPLAIN on the two queries, and what
happens if you put an ORDER BY clause on them both? Mysql is free to
optimize both queries differently, and happens to return the records in
different order for your two queries.
--
Dan Nelson
dnelson@stripped
