Hi, we have already done that and it was still slow. And isn't that parameter used only for DASL queries?
Regards, Bruno -----Original Message----- From: Pontus Strand [mailto:[EMAIL PROTECTED] Sent: terça-feira, 8 de Março de 2005 12:05 To: 'Slide Users Mailing List' Subject: RE: Database performance You can put the following parameter into your nodestore configuration: <parameter name="use-rdbms-expression-factory">true</parameter> This reduces the number of queries significantly. You can also go to the archive for this mailing list and search for the subject "Slide search performance issues", there are some other pointers there. Best regards, Pontus Strand > -----Original Message----- > From: Bruno Silva [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 08, 2005 11:16 AM > To: slide-user@jakarta.apache.org > Subject: Database performance > > > Hi, > > I was wondering what kind of performance we should expect > when using the > JDBCStore. In our tests, a single propfind on a collection > with 100 files > makes 1200 queries to the database! We have already defined > rdbms-expression-factory and looked at the source code and it > looks like it > gets the info for the collection and then queries the db for each file > individually. Is this the regular behaviour?? > > Thanks, > Bruno Silva > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]