I have just moved a database from Access to SQL server 2005 and added three
(automatically indexed) full-text indexes. This works fine through my vb6-ado
program and users are happy because searches are reduced by factors.

Except the first user in the morning. The VB6 program has to handle at least
one timeout, after that everything OK. It seems that the indexes have
waking-up problems.

Any suggestions?

Thank you
Jos

This is pretty much just a guess but it sounds like your full text indexes
get pushed out of memory during the night - probably by your nightly backup
jobs. If this is the case, have your nightly jobs do a full-text query
after they're done to get the indexes reloaded.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"jos" <jos (AT) discussions (DOT) microsoft.com> wrote