Subject | Re: [firebird-support] Re: Why not sweeping? |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2012-07-10T18:32:10Z |
Hello, fdt4y!
Tuesday, July 10, 2012, 7:17:56 PM, you wrote:
f> After some more investigation I found that our main user interface
f> client app starts a single long running read transaction used to pull data for
f> display in its grids. All updates are executed in small/short
f> 'write' transactions. It is common for our client app to run 23 hours in a day (in a
f> warehouse running shifts). We use FIBPlus components which works
f> great, but now I'm faced with a catch-22. How can I commit/rollback the 'long read'
f> transaction without disconnecting the FIBDatasets which feed the
f> grids. If I do commit the read transaction, all the grids lose their content.
read-only transaction must be real read-only, not "logically read-only". So, you
need to set this transaction parameters to
read
read_committed
rec_version
nowait
--
Dmitry Kuzmenko, www.ib-aid.com
Tuesday, July 10, 2012, 7:17:56 PM, you wrote:
f> After some more investigation I found that our main user interface
f> client app starts a single long running read transaction used to pull data for
f> display in its grids. All updates are executed in small/short
f> 'write' transactions. It is common for our client app to run 23 hours in a day (in a
f> warehouse running shifts). We use FIBPlus components which works
f> great, but now I'm faced with a catch-22. How can I commit/rollback the 'long read'
f> transaction without disconnecting the FIBDatasets which feed the
f> grids. If I do commit the read transaction, all the grids lose their content.
read-only transaction must be real read-only, not "logically read-only". So, you
need to set this transaction parameters to
read
read_committed
rec_version
nowait
--
Dmitry Kuzmenko, www.ib-aid.com