MySQL Forums
Forum List  »  Performance

Re: Queries slow down daily, optimizing helps -> why?
Posted by: Kaspar Con
Date: February 18, 2009 11:57AM

yes Aftab Khan, you are perfectly right that queries like that could not use any Index and I should use a Fulltext-index. Thanks for pointing that out and providing a much better way!

My question was more about why the Server slows down and after optimizing the tables the same (bad) query runs many times faster than beforehand.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Queries slow down daily, optimizing helps -> why?
2383
February 18, 2009 11:57AM
2200
March 18, 2009 03:58AM


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.