[cfaussie] Re: verity element limits (rows times columns)

[Barry Beattie]

>> Verity just flagged that the size was over the allowable limit for the CF license and did indeed return an empty record set. thanx for your reply, Kym.   was your solution to give up on Verity and switch to Lucerne?   cheers   Barry Beattie CF Web Developer Alpha Business Systems [EMAIL PROTECTED]   Ph: +61 07 3216 0999   Unit 1, 31 Thompson Street Bowen Hills QLD 4006 www.alphabus.com.au   Virus Disclaimer: Please note that this email may contain computer-generated file(s) as an attachment.  Whereas we take every effort to protect our files from computer virus, we recommend that you check the file(s) with your own virus detection software prior to opening it.  If you would prefer to receive a hardcopy of the file please email or phone. Alpha Business Systems does not accept liability for the consequences of any computer viruses that may be transmitted with this email. Confidentiality: This email and any attached files are intended solely for the addressee(s) and may contain confidential and privileged information. If you received this email in error, please advise us by return email or phone and disregard the contents and immediately delete it and destroy any copies     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kym Kovan Sent: Friday, 3 December 2004 9:51 AM To: CFAussie Mailing List Subject: [cfaussie] Re: verity element limits (rows times columns)   Hi Barry, “Verity engine has a limitation of 64,000 elements (rows times columns). If this number is exceeded, Verity throws an error and ColdFusion simply returns an empty result set”   while we’ve been having a bit of grief with verity, we do have collections that index lots or records (20+ cols times many thousands of rows), seemingly without issue.   can anyone confirm that the 64k element limit is actually “real”? they have actually hit this number as a “brick wall”? If you remember my post of a few weeks back regarding the communityguide site and its need for massive collections, the actual number was 460K rows in the database at the time (its got bigger since then <g>). Verity just flagged that the size was over the allowable limit for the CF license and did indeed return an empty record set. AFAIK the limit is rows in the database ("documents" as they put it), no connection to total matrix size in terms of licensing and no error seen in the literal sense. -- Yours, Kym --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/