Results 1 to 1 of 1
February 11th, 2007, 06:35 AM #1
FullText Seach catalog index - long proccess ? how to speed?
- Join Date
- January 22nd, 2007
i need some help with fulltext search on sql server 2000
i have 2 main quastion:
1) my data table contains 10 milion rows - when i am running the FULL population IT take like more then 10 hour to finish the proccess
my full text search it is just on the title(one colums) how can i speed the proccess ? i need to upload every week the same amount (10mil items)
2) when i am runnig the full text search (FULL population) its take all my cpu and memory (im using amd 1.8 with 4gig ram) so i decided to run the proccess on diffrent box and then upload the FTdata to the server
BUT when i restart the search server (after i past their the new cataloge that is already mad) - the server do recovery and then start the FULL population agine!
How can i avoid the server from doing the FULL population , and let it Use the catalog file without -re populate !
By Jim Sprouse in forum Newbie Affiliate FAQs & Helpful ArticlesReplies: 16Last Post: June 24th, 2008, 06:56 AM
By jackson992 in forum Programming / Datafeeds / ToolsReplies: 1Last Post: April 26th, 2008, 01:14 AM
By Joe Mediate in forum Midnight Cafe'Replies: 14Last Post: March 20th, 2008, 10:58 AM