Hello,





   I have written an search Engine using Asp and SQlserver. It was working

well and very speedy for approx. 1 lakh records. I also created Full text

indexing and all other index that are necessary to speed up the search

Query in Sqlserver.

The Data in the sqlserver database is keep on growing, so the search

engine is becoming slow. How to improve the speed of the search engine for

lakhs and lakhs Data in the sqlserver database?



  This is my immediate requirement, please tell me the solution for this

problem asap.



(For those of you that don't know, a lakh is 100,000 - moderator)