On Fri, Aug 15, 2008 at 2:37 AM, Fabian Groffen
On 15-08-2008 09:08:23 +0200, Martin Kersten wrote:
Niels Nes wrote:
Using your create statements and queries I could see that the plans for both q1 and q2 are equal, ie they should be the same speed. If not something is wrong, ie wrong version or so. Question remaining is are the queries both on the same 'too' slow speed or are the fast.
How about the compiler optimizer settings? e.g. --enable-optimize and friends
The output of `mserver5 --version` will help a lot in that respect.
I recompiled the server without the optimization flag, the output of mserver5 --version now just looks like this: Compilation: gcc -O2 -std=c99 -fgnu89-inline The performance difference between the 2 queries remains the same. Average of .4 seconds when the single predicate is first, average of 1.9 seconds when it's placed last. One other thing to note, the -G flag doesn't appear to have an impact one way or the other when using mclient., I get the same results. Also, when I use jdbc/squirrel I get the same results as well.