| Subject | Synchronisation between two processes |
|---|---|
| Author | Bryan Cole |
| Post date | 2014-07-11T14:31:09Z |
Hi,
I have two client processes (on uptodate linux host) accessing a firebird database using the direct-file-access method (libfbembed.so). Most of the time, when a write transaction is committed in one process the data is visible in the second process more-or-less immediately. Sometimes (apparently depending on the order of DB access, size of the table and phase of the moon), it takes much much longer (>14 seconds) for changes to show up in the second process. Is there a method to ensure that the results of a transaction are immediately available to other processes?
I'm using firebird-2.5.2, superclassic server on linux (Fedora20). All DB writes/reads are within the context of a transaction.
Thanks,
BC
I have two client processes (on uptodate linux host) accessing a firebird database using the direct-file-access method (libfbembed.so). Most of the time, when a write transaction is committed in one process the data is visible in the second process more-or-less immediately. Sometimes (apparently depending on the order of DB access, size of the table and phase of the moon), it takes much much longer (>14 seconds) for changes to show up in the second process. Is there a method to ensure that the results of a transaction are immediately available to other processes?
I'm using firebird-2.5.2, superclassic server on linux (Fedora20). All DB writes/reads are within the context of a transaction.
Thanks,
BC
| -- Group Leader, Technical Development Group - Teraview Ltd. Platinum Building, St. John's Innovation Park, Cambridge CB4 0DS, UK. tel: +44 (0)1223 435386, fax: +44 (0)1223 435382, web: www.teraview.com Registered Number: 04126946, VAT Number: 770 8883 84 ...preferred document formats: ODF (ISO/IEC 26300:2006), PDF |