Re: Slow Query Time for Many Records from Large Table
Posted by:
Jay Pipes
Date: November 08, 2005 04:10PM
OK. To be honest, .06 seconds is not particularly a long time, and with the query cache enabled, that type of query will return instantaneously when found in the cache. Is it possible for you to post the output of an EXPLAIN SELECT for the queries that are taking aroun .77 seconds to finish? My only thought is that perhaps the key_buffer needs to be adjusted to ensure that all joined keys are found in the buffer and that no disk reads are required...
Let me know,
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
2536
November 08, 2005 05:04AM
1372
November 08, 2005 08:08AM
1336
November 08, 2005 02:21PM
1374
November 08, 2005 02:40PM
1377
November 08, 2005 03:34PM
Re: Slow Query Time for Many Records from Large Table
1470
November 08, 2005 04:10PM
1427
November 08, 2005 05:09PM
1550
November 08, 2005 09:51PM
1318
November 11, 2005 05:54AM
1347
November 08, 2005 08:05PM
1325
November 11, 2005 06:10AM
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.