MySQL Forums
Forum List  »  Performance

Query performance cut
Posted by: marius hagiu
Date: January 15, 2005 09:20AM

hi there!
i have a problem with my mysql server
i run a java aplication on a mysql 4.0.15 and although it worked really well for about 6 months, now after 30 min of running the sorting and finding features are drastically reduced (about 2-3 minutes to sort a few thousand records).
is this because of poor indexing?
i left the mysql variables untouched.could this be the problem?
and why i get this problems now and not from the first time?
thanks in advance!

Options: ReplyQuote

Written By
Query performance cut
January 15, 2005 09:20AM
January 17, 2005 09:58AM
January 19, 2005 12:11AM

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.