Hi Dennis I see this is an old post but incase you are still out there:
We are about to breach the 250k limit so have bought standalone Verity K2 but the install and setup is not straightforward. Can you shed any light on this or point me in the direction of any online support/help. We cannot seem to find much that is CF specific, Do we really need to install Verity standalone? Ben >Hi, > >Once again here is what should be and most likely is a simple question about >Verity. We are planning a project where all relevant data will reside in a >database. In the past we have used Verity to offer search functionality for >projects of this type. However most of those were simple 1,000 to 8,000 >record databases. This project will support on average over 1.5 million >records and could get as high as 10 million records. > >What I am trying to ascertain is the limits of an indexed verity collection >using the cfsearch tag and I have found these items on the macromedia web >site: > >====================== [ cut here ]========================== >CF4.5 >ColdFusion 4.5 comes bundled with a custom implementation of the Verity97 >search engine... > >Collections Limits > >There is no set limit to the size of Verity collections. The hardware and >RAM of the index server also affect its performance. > >CFSEARCH Limits > >CFSEARCH cannot return a result set greater than 64K. This simply means if >you have a large enough collection and your search terms are broad enough, >you will hit this limit and an error will be thrown. A best practice would >be to catch the error and inform the user that he or she needs to narrow his >or her search terms. > > >CF5.0 >The restricted version of K2 Server installed with ColdFusion has document >search limits as follows: 125,000 documents (ColdFusion Professional) and >250,000 documents (ColdFusion Enterprise). Macromedia Spectra sites have a >limit of 750,000 documents. > >====================== [ cut here ]========================== > >Keeping in mind that we are searching Verity collections from database >queries and NOT files, my questions are: > >1) In CF 4.X does the 64K CFSEARCH limit mean all data returned in the >Custom1, custom2, key, Title and summary fields cannot exceed 64K >regardless? Does the maxrow setting negate this limitation? Since the >summary field returns 500Bytes per record this would tell me that cfsearch >can only return approximately 128 records per search. We routinely have >searches (CF4.X) that return 2 to 4 times that amount with out error. Can >some one explain what I am misunderstanding? > >2) Does cfsearch in CF5 have the same limitations? > >3) In CF5 does the limitations of 125,000/Pro and 250,000?enterprise >documents apply for indexing/searching database records? Can I only index >125,000 or 250,000 records (Pro/Enterprise)? > >4) What other limitations in the verity implementation in CF5 are there that >we should be aware of? > > > > > >Best regards, > >Dennis Powers >UXB Internet - A Web Design and Hosting Company >tel: (203)879-2844 fax: (203)879-6254 >http://www.uxbinternet.com/ >http://dennis.uxb.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
