2009/5/14 Dmitry Yemanov <dimitr@...>

>
>
> ruan_h wrote:
> >
> > Had a query running much slower in 2.1.2 than in 2.0.3
>
> I suspect you compare Linux vs Windows builds, or release vs debug ones.
> Could it be true?
>
> I'm comparing LI-V6.3.2.18118 Firebird 2.1 vs LI-V6.3.1.12855 Firebird 2.0.
> Both are running on Linux, CS mode.
>
>
> > Both 2.1.2. and 2.0.3 choose this plan:
> >
> > PLAN (EXCLUDEDFILE INDEX (EXCLUDEDFILE_IDX1, EXCLUDEDFILE_IDX1))
> > PLAN (ALLFILE NATURAL)
> >
> > 2.0.3 does 3 natural reads on AllFile, and 2 index reads on ExcludedFile,
> because it applies allfile.filename = '1.TXT' first.
> >
> > 2.1.2 does 3 natural reads on AllFile, but also 6 index reads on
> ExcludedFile, because it applies allfile.filename = '1.TXT' last.
>
> On my machine, v2.1.2 produces 2 index reads on ExcludedFile. The same
> is for v2.0.5.
>
> Thanks for running the script, Dmitry. But I just ran it again to be sure,
> still the result is 6 index reads on ExcludedFile with v2.1.2 but 2 index
> reads with v2.0.3.
>
> Dmitry
>
>
>

[Non-text portions of this message have been removed]