----- Original Message -----
From: "Phil Shrimpton" <phil@...>
To: <ib-support@yahoogroups.com>
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
the
> transaction is closed (committed or rolledback), everything belonging to
that
> transaction becomes invalid.


Does this mean if I have many small transactions, I'll need to create the
prepared
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
connection?

Thanks.

Regards
Kenneth