Igor Tandetnik wrote: > > By the way, for most queries you will find that the execution time > grows as the OFFSET grows. To implement OFFSET X, the engine would > enumerate records from the beginning and simply ignore the first X-1. > Retrieving the last pageful often takes almost as long as retrieving > all the records.
I have noticed exactly that behaviour recently in MySQL and MSSQL (where it had to be emulated). This was when implementing a web paging access as the original poster is doing. -- Lindsay
