2012年2月19日星期日
fts catalog size
I am new to using FTS for searching, so please forgive the ignorance if there is an obvious answer. I've set up a table specifically to hold searchable data rather than have a number of table joins for searching. I've imported about 1/4 of the data into the table and set up a catalog on the table. The catalog is currently 62 mb. Is there a suggested limit to a catalog size for FTS and if so, is there a way to set up a catalog so that when it reaches this size, it splits off and creates a 2nd catalog? Thanks.No you can't throttle the size, nor can you have another catalog created dynamically. Note that a full text index for a table can't span catalogs, ie one index one catalog. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com wrote in message news:ec61e74c-e1b9-4f40-a99c-0c7ada543225@.discussions.microsoft.com... I am new to using FTS for searching, so please forgive the ignorance if there is an obvious answer. I've set up a table specifically to hold searchable data rather than have a number of table joins for searching. I've imported about 1/4 of the data into the table and set up a catalog on the table. The catalog is currently 62 mb. Is there a suggested limit to a catalog size for FTS and if so, is there a way to set up a catalog so that when it reaches this size, it splits off and creates a 2nd catalog? Thanks.
订阅:
博文评论 (Atom)
没有评论:
发表评论