On Monday 14 January 2002 19:06, matt stewart wrote: > but presumably if i'm doing a SELECT count(*) FROM Designs WHERE Keywords > LIKE "%sport%" > followed by a SELECT * FROM Designs WHERE Keywords LIKE "%sport%" LIMIT > 0,20 > > it's still using nearly as much processing time as just returning all the > designs and just using a get_num_rows and then only using the first 20? >
Possibly, I don't know. BUT if query returns 8000 records as opposed to 20, then it definitely uses up a bit more memory. This may be an issue if you have loads of such queries happening simultaneously. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* Love is not enough, but it sure helps. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
