Hi, On Tue, 2002-03-05 at 10:53, destr0 wrote: > Is it faster for mysql to return all of the rows in a table, or to return a > set of rows picked out with a call like LIMIT 20, 40
Well, the server has to first create the whole result set in the proper order etc, before it can do the limit. But then, of course it's quicker. Less data to send to the client, less data for the client to process, and the server can clear some space (RAM or disk) and gains an idle thread sooner (less CPU). So, certainly LIMIT can be good in lots of ways! Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
