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

-- 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