Subject | IBO - Long time opened Query |
---|---|
Author | Aleš Kahánek |
Post date | 2003-01-06T06:16:09Z |
Hi,
I have a small question: suppose that there is a TIB_Query opened after
application start and stays opened until the application is closed. This can
last several hours. The TIB_Query is opened in TIB_Transaction with
AutoCommit=true.
Question is: in multiuser environment, can this approach have substantial
impact on Firebird performance and resources, especially if there are aprox.
10-20 of such queries in every application?
Thank you
Ales
I have a small question: suppose that there is a TIB_Query opened after
application start and stays opened until the application is closed. This can
last several hours. The TIB_Query is opened in TIB_Transaction with
AutoCommit=true.
Question is: in multiuser environment, can this approach have substantial
impact on Firebird performance and resources, especially if there are aprox.
10-20 of such queries in every application?
Thank you
Ales