
May 11th, 2004, 09:54 AM
|
|
Contributing User
|
|
Join Date: May 2004
Posts: 105
Time spent in forums: 1 h 12 m 41 sec
Reputation Power: 5
|
|
|
full text search indexing
Hello
Are there any ways to make indexing as fast as possible regarding full text search in SQL Server 2000? Here what I am talking about.
I have a table with full text search option configired for that table. I have made a full population and switched "Change tracking" and "background index update" on. The table contains "unique id" field, text field (which is used in full text search) and timestamp field.
I receive about 1 text story per second (about 8K of text). I see the story in my dialog application. It takes about 20 seconds to index the story and after that I can look for that story by any word in that story. 20 seconds is too much.
What can I do to enhance indexing performance to maximum and reduce indexing time to as little as possible?
Thanks a lot
|