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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-05-08 : 10:07:06
|
| I'm still trying to understand the frequency needed for running incremental updates for full-text catalogs. A consultant requested a full population be run every day at 5:00pm and incrementals be run every 3 minutes. My question for you is if I change the incremental frequency to every hour, wouldn't data changes still be available to the application between incrementals? Isn't the purpose of the incremental simply to update the full-text index so therefor its benefit is in terms of performance, not data availability. The consultant seams to think any updates made between incrementals will not be available to the application until an incremental is run.Thanks, Dave |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-08 : 10:26:07
|
| The data won't appear in any query that uses then index until the index is updated.If you have queries that don't use the full text index then the data will be returned but not via the full text index.So yes the data will be available between incrementals but I guess you have a reason for the full text indexes and the 3 min incrementals.Another option is to access the new data via other structures and to remove old data from those structures at the incremental - you might find that using this method you can cope with just the overnight rebuild.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-08 : 10:29:27
|
| Maybe enable automatic track changes? |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-05-08 : 10:30:23
|
| I understand. Unfortunately I don't think they are going to change their code. What bugs me is having to filter through all of the information messages in the SQL log every time an incremental is run. |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-05-08 : 15:56:10
|
| Any idea what type of performance hit there will be using WITH CHANGE_TRACKING? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-09 : 11:12:55
|
| Should be light than incremental population. |
|
|
|
|
|
|
Understanding Incrementals with Full Text Indexes