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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
