Xueron Nee wrote:
Hi all,


There is a table contains about 60,000 rows. where select from this
table with 'order by xxx' statement, it is tooo slow. but if i do it
without 'order by xxx', it works fine.

Is there any tips and suggestion for me? Thanks!

Add an index to the 'xxx' column?

That's not a lot of information to go on.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to