Re: Optimizing for long queries? >> 40% faster by changing INDEX_INTERVAL

2004-07-01 Thread Julien Nioche
; <[EMAIL PROTECTED]> Sent: Thursday, July 01, 2004 2:32 PM Subject: Re: Optimizing for long queries? >> 40% faster by changing INDEX_INTERVAL > A similar experiment with 500 shorter queries shows a 20% speed improvement. > (see xls file for details) > By shorter query I mean something

Re: Optimizing for long queries? >> 40% faster by changing INDEX_INTERVAL

2004-07-01 Thread Julien Nioche
L PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 01, 2004 10:53 AM Subject: Re: Optimizing for long queries? >> 40% faster by changing INDEX_INTERVAL > I got a little bit deeper in my experiments with INDEX_INTERVAL. In a > previous mail to the user list I reporte

Re: Optimizing for long queries? >> 40% faster by changing INDEX_INTERVAL

2004-07-01 Thread Julien Nioche
I got a little bit deeper in my experiments with INDEX_INTERVAL. In a previous mail to the user list I reported a 10% improvement over the regular setting (128) with one of my application. I refined the measures by taking the time spent not in the whole application, but in a method that encapsulate