Repeated Query Execution - Strange Behavior
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
Subject
Views
Written By
Posted
Repeated Query Execution - Strange Behavior
3175
December 28, 2004 03:39AM
2741
December 31, 2004 07:43PM
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.