Subject Re: Re[2]: [ib-support] Re: just if you are curious
Author Kenneth Foo
Hi Phil

----- Original Message -----
From: "Phil Shrimpton" <phil@...>
To: <>
Sent: Sunday, February 23, 2003 6:42 PM
Subject: Re: Re[2]: [ib-support] Re: just if you are curious

> On Saturday 22 February 2003 18:33, you wrote:
> Hi,
> > If I understand correctly, the JayBird driver doesn't allow prepared
> > statements to persist beyond a commited transaction.
> No 'component' set allows this, as FB does not allow this. Basically,
> everything in FB is only valid within the context of a transaction, when
> transaction is closed (committed or rolledback), everything belonging to
> transaction becomes invalid.

Does this mean if I have many small transactions, I'll need to create the
statements many times ..thus causing FB to compile the same SQL string over
and over again?
Will FB perform some form of caching of the compiled statements within the