--- 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

client

> loop. (The bug does not affect calls made from within a procedure

or

> trigger). The cause is in an API macro that fails to reset the

input

> parameters in the XSQLDA parameter structure when returning to the

client.

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.