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 |
|
hitenkandoliya
Starting Member
3 Posts |
 Posted - 2008-05-26 : 05:02:30
|
| I did implement full text on one of the my database table using Catalog file. After implementing full text search my full text search Query given result in 5 sec(elapsed time). but after 3 hrs when i did execute same query its take longer time to execute approximately 17 sec. and after one day its take too much time like infinite !!. I did nt found any reason. when i checked log file Warning: Failed to get MSFTESQL indexer interface for full-text catalog Kindly help me to overcome fro the problem. its very urgent.Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 20:22:26
|
| How often do you repopulate catalog? With diff population? |
 |
|
|
hitenkandoliya
Starting Member
3 Posts |
Posted - 2008-05-27 : 07:56:54
|
| Hi Rmiao,I am populating catalog with use of schedule catalog population..I am doing population one time in a day. |
|
|
|
hitenkandoliya
Starting Member
3 Posts |
Posted - 2008-05-27 : 11:29:33
|
| Hi,I did do further study of log file and i got some other error messages are as under.Changing the status to MERGE / PAUSE/RESUME for full-text catalogReinitialized full-text Auto population for table ...after a temporary failure.The full-text catalog health monitor reported a failure for full-text catalog "ABC" |
|
|
|
Jon G
Starting Member
31 Posts |
|
|
|
|
|
full text search trouble