Chris <mailto:[EMAIL PROTECTED]>
    on Wednesday, May 05, 2004 10:56 AM said:

> If you're using MySQL 4+ you could use the SQL_CALC_FOUND_ROWS flag
> in the select statement.
> 
> It causes the query to count the number of rows it *would have*
> returned if there had been no limit clause.

do you know if that's any faster than doing a "SELECT COUNT(*) FROM
table WHERE ..." ?


chris.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to