Re: Queries slow down daily, optimizing helps -> why?
Posted by:
Rick James
Date: February 19, 2009 01:52AM
A possible explanation for speed difference...
Some of RAM is being used as a 'cache'. OPTIMIZE brings the entire table and indexes into memory (since it will fit). Then the SELECT can do its job without touching the disk.
If you don't run that SELECT for a while, and if other tables are busy, the data may get flushed from cache. Then when you run your SELECT again, it has to hit the disk.
I often find a 10x difference between a query that has to run from disk versus running from memory.
When the SELECT is slow, what happens if you promptly run the SELECT again? I expect it to be fast the second time.
Is "schul" a whole word? Or only part of a word. I don't know, for example, whether FULLTEXT understands German compound nouns. "Strasse" is probably not found in "Bahnhofstrasse" using fulltext. But it would be found using LIKE '%strasse%'.
Subject
Views
Written By
Posted
4491
February 18, 2009 04:54AM
2296
February 18, 2009 09:04AM
2392
February 18, 2009 11:57AM
2382
February 19, 2009 01:00AM
Re: Queries slow down daily, optimizing helps -> why?
2335
February 19, 2009 01:52AM
2351
February 19, 2009 03:32AM
1780
February 19, 2009 05:08AM
2226
February 19, 2009 12:24PM
2310
February 19, 2009 10:53PM
2426
February 20, 2009 08:34AM
2207
March 18, 2009 03:58AM
2325
February 21, 2009 06:15AM
2277
February 24, 2009 10:02AM
2487
February 26, 2009 02:30AM
2109
February 26, 2009 09:56AM
2299
February 26, 2009 08:14PM
2318
February 27, 2009 01:38AM
2202
February 27, 2009 07:56PM
2208
February 28, 2009 06:20AM
2533
February 28, 2009 03:43PM
2327
February 27, 2009 04:21AM