Robert Cummings <mailto:[EMAIL PROTECTED]>
    on Thursday, August 21, 2003 4:46 PM said:

> Don't retrieve ALL the queries then
> only display a subset. Otherwise what's the point of using the LIMIT
> clause for conservation of resources?  The "SELECT COUNT( * ) FROM
> foo" query is usually optimized to be extremely fast so the first
> query is almost negligible in contrast to the second.

Heh... I've never really used COUNT() so I'll have to see how much it
speeds up my searching. :)


Good idea!

Chris.

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

Reply via email to