Dear All,
I have a heavy table on sql server 2005 with enable full text search on it, I want to get top N newest data by id or insert date with specific full text.
some query result with "Containstable" return over 500,000 record and take over 1 min, that is very bad, also top n by rank not good for me because maybe return old data
Table info: Auto increment field, Id bigint as primary key Info Field type is VARCHAR(MAX) to using full text Insert Date Field and desc index on it
- More than 21 million record now
- Insert More than 600,000 record per day
Hardware:
- 8 CPU 2.2 GHz (really 2 quad core cpu)
- 16 GB RAM
Software:
- Windows 2003 x64
- SQL Server 2005Standard
Have any idea