SQL Server 2012 Express on a Win7-machine.
I have a table with 18'000 records, 10 fields with a fulltext index. After filling in that 18000 records it takes hours to complete fulltext-indexing. Is there a possibility to speed up this process? That's how I create it:
CREATE FULLTEXT INDEX ON myTable
myFirstColumn KEY INDEX ixFTfirst ON ftCat
WITH StopList = OFF
Second Problem: after inserting a new record it lasts minutes until I can find this record with "CONTENTS" but I should find it immediately. Thanks for your help, Peter