What's an optimal scenario of using separate transactions in TpFIBDataSet in a multi-user Application? I mean what are best transaction settings for the two separate transaction?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
Question: What's an optimal scenario of using separate transactions in TpFIBDataSet in a multi-user Application? I mean what are best transaction settings for the two separate transaction?
Answer: TpFIBDataSet can work with two separate transactions. SelectSQL can work in the context of one transaction and all modifying queries are executed in the context of the other transaction. This helps to avoid transaction conflicts in multi-user environment. But transaction settings greatly depend on your business model and application architecture. For example, if you use separate transactions and the AutoCommit mode you can not always use master-detail links, etc. So, everything depends on your conditions. For more details also read an article
Transactions in InterBase/Firebird: how to use them in FIBPlus
Coming from a Java/OO background, it has been a real pleasure working with FIBPlus in Delphi. I'm very picky about good code design, and FIBPlus has it in spades! >>Nathan Probst, Co-Founder Kazoie LLC
