I was under the impression that even "Enterprise" had a
limit of 250,000 records max. Perhaps with CF7 this will change as a new Verity
engine is likely to be included.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kym Kovan
Sent: Friday, 3 December 2004 10:51 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: verity element limits (rows times columns)
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 weve 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: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
