MySQL Forums
Forum List  »  Newbie

Re: Question about LIMIT
Posted by: Rick James
Date: December 22, 2010 04:38PM

If the INDEX can be used for the ORDER BY, then LIMIT is much faster than reading the whole table.

http://forums.mysql.com/read.php?10,380718 (Efficient MySQL for pagination of large amounts of data on website)
http://forums.mysql.com/read.php?10,360578 (join in union)
http://forums.mysql.com/read.php?115,355941 (Query that returns indexed fields involves FILESORT, why?)
http://forums.mysql.com/read.php?24,291646 (Very Slow Simple Query)
http://forums.mysql.com/read.php?10,292296 (break mysql query? Is this possible in my sql)
http://forums.mysql.com/read.php?125,246731 (Alternative to FOUND_ROWS())
http://forums.mysql.com/read.php?10,243777 (Query performance question (using index slows down?))
http://forums.mysql.com/read.php?24,240838 (Slow search query)
http://forums.mysql.com/read.php?10,239876 (Query performance on database with joins)
http://forums.mysql.com/read.php?24,234339 (MySQL Performance Tuning on my server)

Options: ReplyQuote


Subject
Written By
Posted
December 22, 2010 07:59AM
December 22, 2010 08:41AM
December 22, 2010 08:50AM
December 22, 2010 10:47AM
December 22, 2010 03:05PM
December 22, 2010 03:16PM
December 28, 2010 08:06AM
Re: Question about LIMIT
December 22, 2010 04:38PM
December 28, 2010 08:08AM
December 28, 2010 03:23PM
December 29, 2010 08:26AM
December 29, 2010 08:53AM
December 29, 2010 09:42AM
December 29, 2010 09:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.