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