Sorry, from my phone, sobad formatting and terse. What transaction isolation mode(s) are you using? Ordinarily direct file access is limited to one process. What version of Firebird?
Ann > On Jul 11, 2014, at 10:31 AM, "Bryan Cole bryan.c...@teraview.com > [firebird-support]" <firebird-support@yahoogroups.com> wrote: > > > > 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 > >