none
full-text search performance. RRS feed

  • Question

  • Hello,

    We have a articles full text table that has more than 16 Millions of rows, and the full-text column is a ntext column which stores the full article content. 

    I've read a pervious posting about building time sensitive search and embedding the date in the full-text field would enhance the performance.   As we need to do a time-sensitive search as well, so I tried that.  However, our search still take about more than 1 mins to complete.  Using ranking doesn't really help, as we need to search for all the articles in the table.  I've also read some articles about optimizing the virtual memory, but I'm wondering if we should change the setting as we haven't had any memory problem... 

    Is there any other suggestion to enhance the performance?

    Thank you very much,

    Sincerely,

    Hsiao-I

    Friday, April 21, 2006 2:05 PM