Full Text Search Estimated Update Time

  • Hi I want to learn that when we create full text indexes in auto change tracking mode, how much time it is needed indexes to be updated, I have to give an estimated time to developers, I know it changes from implementation to implementation, but my initial knowledge there will be 200,000 rows initially and ~1500 row insert/day. Is update time be in the range of minutes, seconds or miliseconds?

  • Your best bet would be to restore a copy of your database to a test server and then run your tests on it and time them as you do them.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply