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/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
