RE: [PHP-DB] Performance in MySQL Result Question
| From: | John W. Holmes | Date: | Sat, 15 Mar 2003 21:09:27 +0000 |
| Subject: | RE: [PHP-DB] Performance in MySQL Result Question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26398@lists.php.net to get a copy of this message | ||
[snip]
> 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?
[snip]
Use a limit, it's efficient. You can't do a full select on one page and
somehow carry the result over to another page with any kind of
efficiency.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/