Re: Queries slow down daily, optimizing helps -> why?
Posted by:
Kaspar Con
Date: February 21, 2009 06:15AM
I tested it once again and I actually was wrong in my answer about the query speed when doing the same query several times.
It is not that simple.
If the server is slow the first query takes 6,6 s, the second (same) ALSO takes 6,6 s and the third one is fast with 31 ms. (Actually the time is the time to serve the page but there is not much more than the query in question).
Using another term starts the same procedure, slow, slow, fast.
But: It is not always like that. Sometimes queries are three times slow, some times only once and I could not find any similarities in the searchtearms between similar bahaviour.
I think this is kind of strange, if the reason should be that the table has to be loaded into the cache.
BTW: Rising the key_buffer to 3 GB did not have any positive effect.
Any more ideas?
Sami
Subject
Views
Written By
Posted
4482
February 18, 2009 04:54AM
2293
February 18, 2009 09:04AM
2389
February 18, 2009 11:57AM
2380
February 19, 2009 01:00AM
2332
February 19, 2009 01:52AM
2346
February 19, 2009 03:32AM
1777
February 19, 2009 05:08AM
2220
February 19, 2009 12:24PM
2308
February 19, 2009 10:53PM
2424
February 20, 2009 08:34AM
2202
March 18, 2009 03:58AM
Re: Queries slow down daily, optimizing helps -> why?
2319
February 21, 2009 06:15AM
2272
February 24, 2009 10:02AM
2483
February 26, 2009 02:30AM
2105
February 26, 2009 09:56AM
2297
February 26, 2009 08:14PM
2314
February 27, 2009 01:38AM
2200
February 27, 2009 07:56PM
2202
February 28, 2009 06:20AM
2528
February 28, 2009 03:43PM
2322
February 27, 2009 04:21AM