Hi,

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
http://www.interbaseworkbench.com



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

the

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


Regards,

Ann
www.ibphoenix.com
We have answers.


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