Captain Nemo
May 11th, 2004, 11:01 AM
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
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