Subject RE: [ib-support] Prepared statements and resources
Author Martijn Tonies

thanks a lot - I'll be implementing a change in one of our systems soon :)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

At 11:37 AM 12/13/2001 +0100, Martijn Tonies wrote:
>Hi all,
>As we all know, preparing statements uses resources at the server and
>client. But it makes them a hell of a lot faster.
>Is there a problem when keeping your statements prepared for the whole day,
>or even days or weeks? Note that the transaction(s) that have to do with
>statements will be comitted/rolled back...

Prepared statements are associated with a connection - as long
as you are willing to keep the connection open (which is cheap)
there's no great problem with maintaining prepared statements.
Note that having a prepared statement will lock the metadata elements
used in the statement - not from reading or writing, but from
metadata changes.


We have answers.

[Non-text portions of this message have been removed]