RE: [PHP-DB] RE: LIMIT and get_num_rows

you've assumed correctly - so it's definitely faster to do the two queries? okey dokey, then that's the method i shall use. thanks to everyone who's added their thoughts! -----Original Message----- From: Peter Westergaard [mailto:peter@westergaard.ca] Sent: 14 January 2002 14:01 To: php-db@lists.php.net Subject: [PHP-DB] RE: LIMIT and get_num_rows >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? I absolutely think it will not. After all, the table record count should be able to reference the index, (you are running this query against an indexed 'Keywords' column yes?), while assembling the table of returned data will take quite a bit more memory, which is what you're really trying to cut down, I think. Cheers, -Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/02