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