Barry Beattie wrote:
thanx to timely reminder from doug Hughes… http://www.doughughes.net/index.cfm/page-blogLink/entryId-62
he mentions a tech note saying that
“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”
Without seeming like a Verity zealot, this post is a bit silly.
It refers to the size of the result not the collection. Anyone returning a result that large is not doing themselves or their clients any favours. A search result should really be limited to something that people will pratically browse through -- I'd suggest maybe 200 records.
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”?
The only limit is a licensing limit. This depends on the version of CF you are running and is something like 125k documents for Standard and 250k for Enterprise -- though you might want to check those figures.
Note this is a limit for the number of documents indexed. Each physical file represents one document and each database record represents one document.
How this will pan out in CF7 I have no idea. Other than to repeat what others have said -- Verity is recieving a significant upgrade in the next version.
Would I be leaping off to Lucene? Not in a hurry, no. It's certainly not as sophisticated a product as Verity, and has its own headaches. If you need to search very large collections (ie. those that exceed the Verity licensing limits) then Lucene is perhaps something to consider.
Hope that helps,
-- geoff http://www.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/
