Re: Queries slow down daily, optimizing helps -> why?
Posted by:
Kaspar Con
Date: February 19, 2009 03:32AM
This is a very possible explanation! You are right about your assuption that the second query is fast. First one is really slow, next ones fast. But if I change the queryterm it is slow again. Next query with the second term is fast again.
So it looks like a caching problem? Or is it a I/O problem?
Is there anything I could do to avoid it?
'schul' is no whole word, it could be part of a name e.g. Schulz. This is why I could not use FULLTEXT. The query is used to find users whith a username that contains the querystring.
Subject
Views
Written By
Posted
4484
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
Re: Queries slow down daily, optimizing helps -> why?
2346
February 19, 2009 03:32AM
1777
February 19, 2009 05:08AM
2221
February 19, 2009 12:24PM
2308
February 19, 2009 10:53PM
2424
February 20, 2009 08:34AM
2202
March 18, 2009 03:58AM
2320
February 21, 2009 06:15AM
2272
February 24, 2009 10:02AM
2484
February 26, 2009 02:30AM
2106
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
2529
February 28, 2009 03:43PM
2322
February 27, 2009 04:21AM
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.