~Rob
Chris W. Parker wrote:
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