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.