Subject | Prepared statements and resources |
---|---|
Author | Martijn Tonies |
Post date | 2001-12-13T10:37:31Z |
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...
Any comments?
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
[Non-text portions of this message have been removed]
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...
Any comments?
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
[Non-text portions of this message have been removed]