On Wednesday 08 June 2005 01:18, Kevin Burton wrote: > Paul Elschot wrote: > > >For a large number of indexes, it may be necessary to do this over > >multiple indexes by first getting the doc numbers for all indexes, > >then sorting these per index, then retrieving them > >from all indexes, and repeating the whole thing using terms determined > >from the retrieved docs. > > > > > Well this was a BIG win. Just benchmarking it out shows a 10x -> 50x > performance increase. > > Times in milliseconds: > > Before: > > duration: 1127 > duration: 449 > duration: 394 > duration: 564 > > After: > > duration: 182 > duration: 39 > duration: 12 > duration: 11
There is no need for a relational db when you have Lucene :) Thanks for reporting the old and the new times. Regards, Paul Elschot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]