Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

ORDER BY … LIMIT Performance Optimization [message #741] Sat, 17 February 2007 11:58  howachen Messages: 7 Registered: February 2007 Junior Member refer to the article: ORDER BY … LIMIT Performance Optimization http://www.mysqlperformanceblog.com/2006/09/01/order-by-limi t-performance-optimization/ I am facing this problem. I am using the correct index, but the problem is on "large LIMIT", e.g. ORDER BY ... LIMIT 10000,10 we can't avoid this problem in our application, but are they workaround? can data partitioning help? thanks. Report message to a moderator

	ORDER BY … LIMIT Performance Optimization By: howachen on Sat, 17 February 2007 11:58
	Re: ORDER BY … LIMIT Performance Optimization By: Peter on Sat, 17 February 2007 13:50
	Re: ORDER BY … LIMIT Performance Optimization By: donny on Mon, 26 February 2007 10:24
	Re: ORDER BY … LIMIT Performance Optimization By: Alexey on Mon, 26 February 2007 15:27
	Re: ORDER BY … LIMIT Performance Optimization By: Peter on Mon, 26 February 2007 18:19

Previous Topic:	Performance of a database with a lot of tables
Next Topic:	ibdata1 file size

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]