Subject | Re: [firebird-support] Re: What is the proper transaction level |
---|---|
Author | Pavel Menshchikov |
Post date | 2006-08-17T16:25:54Z |
Hello Colin,
c> To avoid "gap" problems with OIT/OAT etc I've just changed my
c> application to use read-only read-committed transactions everywhere.
c> Updates to data are done via read-write transactions. This is achieved
c> using the FibPlus components, where a query (TpFibDataset) can have a
c> read transaction AND an update transaction.
c> I'm also suffering with "blob not found" errors, and many of my
c> queries retrieve blobs.
c> So I have to change back to not using read-only?
You should check how you use FIB+ components regarding BLOBs - FIB+
has an ability to cache BLOBs locally, or write BLOBs separately from
"regular" fields (if regular fields were written succesfully). But
it's off-topic here - ask about your problems and solutions at
devrace.com.
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com
c> To avoid "gap" problems with OIT/OAT etc I've just changed my
c> application to use read-only read-committed transactions everywhere.
c> Updates to data are done via read-write transactions. This is achieved
c> using the FibPlus components, where a query (TpFibDataset) can have a
c> read transaction AND an update transaction.
c> I'm also suffering with "blob not found" errors, and many of my
c> queries retrieve blobs.
c> So I have to change back to not using read-only?
You should check how you use FIB+ components regarding BLOBs - FIB+
has an ability to cache BLOBs locally, or write BLOBs separately from
"regular" fields (if regular fields were written succesfully). But
it's off-topic here - ask about your problems and solutions at
devrace.com.
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com