Re: MySQL Performance

Hello Manuel, On 15-May-00 11:30:52, you wrote: >I use a "Select * from Table order by ..." Statement several (31) times and >MySQL takes about one minute to do this. The Table consists of 120 entrys >(text) . What could that be? If you can live without ORDER BY clauses, do it. The use of ORDER BY requires the server to sort the results after the select search is ended. If you really need the results to be sorted, make sure you have created an index on the tables fields used in the ORDER BY clause. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --