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,

--- In, Pavel Menshchikov
<developer@l...> wrote:
> Hello Nico,
> NC> I replaced some LEFT OUTER JOINS with JOIN statements (I guess
> 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