<eaper66@gmail.com> wrote in message
news:1172006436.512368.43720@v45g2000cwv.googlegroups.com...
> Hello All.
>
> We are having a performance problem with our FTS (running on Sql
> Server 2000 Std vs a MS Commerce 2002 FP1 website. All running on
> Server 2003 OS. SQL and webserver are on different machines). Once
> the re-population is complete, the FTS runs fine.
>
> Each week, we add new items via bulk import to our commerce database
> and then we have to do a full population of the catalog. This takes
> several hours to complete.
>
> Change tracking is on but does not seem to find the changes from the
> bulk insert and an incremental population does not seem to populate
> the changes.
>
> We are looking to minimize the amount of time our search is down.
>
> Any suggestions as to how to improve the performance of this import/
> rebuild?
> Can we 'save' the old FTS files until the rebuild is completed and
> then swap them?
> Can we fix our config for change tracking?
> Can we do any kind of merge with the existing FTS and just the new
> items?
>
> Tia
>