Yup, just text, but the query has extra columns added prior to indexing which is one of the reasons why SQL Full Text wouldn't work. I've already got the Lucence CFCs but switching would be a major PIA. I guess that's why I'm asking if anyone else is using the Unicode Pack - if it did what it was supposed to do it would serve my purposes perfectly but, at the moment, it seems like it's very, very badly integrated with the Verity engine.
----- Original Message ----- From: "Russ" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, March 01, 2007 8:12 PM 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:271191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4