> -----Original Message----- > From: Guido Casper [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 13, 2005 8:44 AM > To: Slide Users Mailing List > Subject: Re: Slide search performance issues > > > Pontus Strand wrote: > > Doing the same search as before on 10000 files yielded a > log file of 55 MB. > > Each one of the 10000 files generated 18 different > select-queries!! 18!!! > > There simply must be a better way to do this! > > <snip/> > > > Have you modified the > > search queries or search methods? Are there any parameters > in Domain.xml or > > similar files that can be added and/or modified to increase > performance? Any > > help at all would be welcome, even if it is just asking > "obvious" questions! > > Did you put > > <parameter name="use-rdbms-expression-factory">true</parameter> > > into your nodestore configuration? >
No, I didn't, mainly because I didn't know it existed. A Google-search on "use-rdbms-expression-factory" gave me only one hit so I wouldn't call this a well documented parameter ... However, maybe I should have found it given that the hit was from this mailing list and regarding searching and indexes ... What exactly is it that this parameter does? Because it does work exceptionally well, doing the same search as before on 40000 files (which gave an OutOfMemoryException after 15 minutes) took about 1.4 seconds now. Now, given the performance boast shouldn't this parameter be on by default when using a JDBC store? After learning of this parameter I must ask this: Are there any more undocumented parameters that will boast performance? I guess this question is primarily directed to the developers of Slide. Guido, you saved our day!! Thank you! Regards, Pontus --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
