Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

FTS Performance Expand / Collapse
Author
Message
Posted Wednesday, July 29, 2009 2:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 15, 2011 5:32 AM
Points: 2, Visits: 110
Hi,

I love the post, and its works great , with the caveat on data size.

I have this working fine on 100M records, I want to get it to 5 Billion. Once I go above 200M records (av len 15 bytes) performance drops to unacceptable levels. Rebuilding the index takes forever, and doesn't actually seem to work properly once its rebuilt.


Is there any way to break up/partition a full text index?

Are there any guidelines on scaling FTS up?

Post #761333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse