Subject | support for 2 transactions in ib_query |
---|---|
Author | Mihai Chezan |
Post date | 2004-07-01T00:50:21Z |
Hi,
This is my first post here. I'm evaluating IBO and Fibplus with firebird
1.5 for building an erp solution.
I've noticed that fibplus uses 2 transactions: 1 for the select (read) and
another for update/insert/delete (write).
Will IBO have this kind of functionality included in the near future? I
think this is a very useful feature because
doing a commit on the write transaction won't invalidate the open cursor
for the read transaction and having the
read transaction set to readonly will allow you to keep the transaction
open for a long time without consuming
too much resources on the server.
Mihai Chezan
This is my first post here. I'm evaluating IBO and Fibplus with firebird
1.5 for building an erp solution.
I've noticed that fibplus uses 2 transactions: 1 for the select (read) and
another for update/insert/delete (write).
Will IBO have this kind of functionality included in the near future? I
think this is a very useful feature because
doing a commit on the write transaction won't invalidate the open cursor
for the read transaction and having the
read transaction set to readonly will allow you to keep the transaction
open for a long time without consuming
too much resources on the server.
Mihai Chezan