Subject Re: Slow execution of first query
Author Nico Callewaert
Hi Pavel,

It seems in IBExpert, the fetch of the whole dataset is about 3 times
as fast as before (I can ask a raise for that :-)

Thanks and best regards,
Nico

--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<developer@l...> wrote:
>
> Hello Nico,
>
> NC> I replaced some LEFT OUTER JOINS with JOIN statements (I guess
a JOIN
> NC> is the same as a INNER JOIN),
> Yes, they are the same (INNER JOIN and JOIN).
>
> NC> and that improves performance.
> Good. May I ask how much?
>
>
>
> --
> Best regards,
> Pavel Menshchikov
> http://www.ls-software.com
>