MySQL Forums
Forum List  »  Performance

Repeated Query Execution - Strange Behavior
Posted by: Yongu Pongu
Date: December 28, 2004 03:39AM

Hi,

I am running a select query on a table with very large data through MySQL control
Center. MySQL version is 4.1.
Some times the query returns data in 5 minutes but some times it takes 10 minutes.
There is no consistency in the behaviour, some times it takes less time 1st and then more time and again less time.
Repeated execution on the query gives different performance figures.

There is no other process running on MySQL server which can affect the performance of MySQL.

Are there any settings on the MYSQL databse which can be modified to get result fast always?

Thanks in Advance.

-YP

Options: ReplyQuote


Subject
Views
Written By
Posted
Repeated Query Execution - Strange Behavior
3077
December 28, 2004 03:39AM


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.