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


Subject
Views
Written By
Posted
Query performance cut
2508
January 15, 2005 09:20AM
1822
January 17, 2005 09:58AM
1790
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.