Re: Performance in MySQL Result Question

[Brent Baisley <brent@landover.com>]

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