1

Topic: Filling of the big table with full-text query search

In a DB there is table FTI_TABLE (ID bigint, TextFTI NVARCHAR (4000)), on column TextFTI the full-text index is constructed.
Daily (time a day) is imported to this table about 200 million lines, the data never changes and is not deleted, only the INSERTION.
I selected strategy, manual change tracking and once a week start of additional filling of an index.
But faced a problem that if an index not  and procedure of an insertion of the data time of filling of the table can began increases from 1 o'clock to 3-5. What me does not arrange, can eat any alternative methods of magnification of speed of performance of the described task?

2

Re: Filling of the big table with full-text query search

1. To pause index update if it takes place (objectpropertyex, alter fulltext index)
2. To interpose the data
3. To restart index update if it has been paused

3

Re: Filling of the big table with full-text query search

invm;
Thanks, something I passed possibility to put on a pause.
Here not, I know, whether there is a sense to use the circuit with timestamp, in help write that can increase speed of an insertion, here only stops necessity to store 8 byte column at such amount of the data. Whether there was at whom an experience of comparing of these two approaches?

4

Re: Filling of the big table with full-text query search

invm;
At tests the suspension population transits quickly, and on the real data happens that only setting on a pause goes 5-7 hours to what it can be connected? Locks like saw