Or get a good search technology which, although will cost, will blow all of them out of the water!
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Russ To: CF-Talk Sent: Thu Mar 01 20:12:21 2007 Subject: RE: Ugly Verity What kind of data are you indexing? Is it just text? You might want to look into SQL Server Full Text Search or Lucene. It's fairly easy to write some wrapper CFC's around lucene's java classes, and you can achieve much better performance, I believe, then Full Text Search or Verity. Russ > -----Original Message----- > From: Gareth Hughes [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 01, 2007 2:28 PM > To: CF-Talk > Subject: Ugly Verity > > Does anyone else on the list use the Verity Unicode pack? I'm using it and > the indexing performance is appallingly bad, perhaps 50 times (or more) > slower than indexing an Englishx collection. If given a multiple row query > to index it will consume way too much memory and eventually timeout. > Indexing a 1000 row query would take hours. It's causing all sorts of > problems (obviously) to the extent where I'm faced with writing hideous > work-arounds to prevent it from killing the server. > > I can't find anything on the web about this so I wonder, could I be doing > something wrong? Is anyone else using the Unicode pack? Can you confirm / > deny the performance difference? > > Thanks > > Gareth > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
