Subject Re: FB: Cross db queries, temp tables etc
Author alex_vnru
--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> At 12:57 AM 28-08-02 +0000, you wrote:
> >4) Does FB create SP's execution plan only once or every time SP is
> >executed?
> Every time the SP is prepared.

Helen, are you shure that you and mr. oneway mean the same under
word "plan"? I'm afraid he mean "compilation". If so, answer should be
- one time at creation of SP.

> Note that Firebird and InterBase
have an
> unresolved bug that means it is necessary for your client to
re-prepare a
> SP that takes input parameters **each time** it is reiterated in a
> loop. (The bug does not affect calls made from within a procedure
> trigger). The cause is in an API macro that fails to reset the
> parameters in the XSQLDA parameter structure when returning to the

My experience shows that this bug was fixed in Firebird's gds32.dll
somewhere in builds 607-609 times. I have'nt nor such a problems
neither need to unprepare and prepare procedures again since that time
using Firebird. I remember I posted simple script and client code when
even unprepare/prepare did'nt help and soon after it Ann fixed the
problem where it should be fixed and stopped need to shamanism :)

Best regards, Alexander V.Nevsky.