I know what you are trying to get at. A full select and a select with limit have the same query speed, but the full select has to transfer all of the selected data, where as a limit only transfers the number of records specified. The more records that match a search, the faster your limit select will be in relation to a full select.

As for improving performance, you would like to avoid re-executing a complex query just to get the next set of records. If you are using MySQL 4 with query caching enabled you don't have to worry. MySQL will be smart enough to cache the query result and won't rerun the exact same query on the database if no data has changed.

On Saturday, March 15, 2003, at 03:57 AM, Jan Bro wrote:

Now comes my question, what is better speaking of performance:
When users go on to the next page, is it better to
provide the select statement again with a different integer for
the limit?

Or is better to do a full select without a limitation on first page.
But than I don't know how to provide the result set for the
next, next, ... page?

Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to