RE: [PHP] paging methodology
| From: | Chris W. Parker | Date: | Wed, 05 May 2004 18:30:25 +0000 |
| Subject: | RE: [PHP] paging methodology | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-185472@lists.php.net to get a copy of this message | ||
Chris <mailto:listschris@leftbrained.org>
on Wednesday, May 05, 2004 11:24 AM said:
> The documentation for the FOUND_ROWS() function is here:
> http://dev.mysql.com/doc/mysql/en/Information_functions.html
ahh... i see. so it essentially allows you to execute one query while
achieving the same two query result.
on a related note... how does BENCHMARK() work? i don't understand their
explanation. the reason i ask is because i'd like to test our the
efficiency of what you are suggesting compared to what i am currently
doing.
SELECT BENCHMARK(500, 'SELECT * FROM table');
although that didn't throw an error, it didn't seem to do anything
either.
thanks,
chris.