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 |
|
cow_pie
Starting Member
1 Post |
 Posted - 2007-10-26 : 13:06:31
|
| I'm running into a problem with Full Text searching. I've narrowed my code that produces the error down to this:SELECT ContentFROM TextJOIN CONTAINSTABLE(Text, Content, 'lake') AS AON A.[KEY]=Text.ID;The first time I run it in the SQL query analyzer it sits there for about 30 seconds and then gives me "Timeout expired (error - 2147217871)." After the first query attempt I can run it as many times as I want and it will work fine (no errors) ... But if I wait for about 30 minutes and then try it again, it will give the the error again on the first try. I've tried using search words that exist and ones that don't exist in the db and they both give the same error, so it's not that it's trying to return too many rows.I'm using Microsoft SQL Server 2005. Any help would be greatly appreciated. Thank you. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-26 : 13:09:11
|
| It rus on the second attempt because the data that it needs is cached in memory by then. After a while that cache becomes stale and evicted from memory, so has to be loaded back in again.Free text query can be slow, only solution that I know of it to reduce the amount of data in the "Container"Kristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 00:49:08
|
| Did you get same issue when run query without join? |
|
|
|
|
|
|
Full Text timing out