Re: paging methodology
| From: | Brian Muldown | Date: | Wed, 05 May 2004 09:43:35 +0000 |
| Subject: | Re: paging methodology | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-185404@lists.php.net to get a copy of this message | ||
Chris W. Parker wrote:
ok. this is what i was already doing in my previous app but i was just looking to see if it could be streamlined some how.You could perform the full (without LIMIT) query once, Cache the results array (using PEAR Cache) and move back-and-forth through this Cached array. Depending on the size of your resultset and the srength of your MySQL Server, this may or may not provide a mild performance boost. -brian