> We have a search page that used full-text catalogs on SQL Server in our > application. They take a very long time because they are > running through close to a million records using the CONTAINSTABLE T-SQL > function. I'm thinking of ways I can make this > quicker, and Verity collections have not been used in our application before. > > I'm trying to decide whether to have one big collection for the million > records (which I guess would take ages to build) or to have > lots of smaller collections per client account. We have hundreds of clients. > > Does anyone know how many verity collections CF can handle? We are currently > using CF5 (would you believe), but we are > migrating to CF9, so answers for both versions would be really great.
As Mark mentioned, I think your real problem is that you'll exceed the total number of documents that Verity allows. It used to be the case that CF Standard's Verity license allowed 250,000 documents, CF Enterprise's Verity license allowed 500,000, and Spectra's Verity license allowed 750,000. I'd recommend that, for this number of records, you consider an alternative. Solr is bundled with CF. Or, you could use a Google Search Appliance, which is comparably expensive, but does search very well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
