Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jon G
Starting Member
31 Posts |
 Posted - 2008-06-02 : 12:01:34
|
| I'm using the Full text functionality of SQL 2005 Express Advanced and it works well.However, the first time a query is run it take 20 seconds or so to actually return the search results. Thereafter, the search results are almost immediate.That would be fine, except that if no further search is performed for approx 15 minutes or so, then we are back to the first scenario where it takes 20 seconds to return the results.I assume this means that the full text catalog is not being held in cache at the server? Is there anyway to force it to do this?My first thoughts were that Full Text within 2005 was an excellent tool, but if the first search always takes a long time then I will have to re-think as I can be sure that customers will get extremely annoyed at the response.Do you know if there is any way around this or if there are any fixes imminent for this problem.....indeed, is it a problem or am I missing a fundamental setup issue?What would be the implications if I created a small console application to perform a full text search once every minute at the server to keep the index cached?many thanks |
|
|
Jon G
Starting Member
31 Posts |
|
|
Jon G
Starting Member
31 Posts |
Posted - 2008-06-02 : 15:30:00
|
| Yep. That fixed it! |
 |
|
|
|
|
|
Full Text Searching with SQL 2005 Express Advanced