Subject What is the best transaction property settings for an interactive application?
Author SoftTech
Greetings All,

Using Firebird 1.5
Delphi 5.1
Interbase express components

TDataSource
TClientDataset
TDataSetProvider
TIBQuery
TIBTransaction
TIBDatabase

I was taught years ago to use Read Committed for anything that needs to
write data back to the database. Then when researching another transaction
property setting issue related to the best property to use for a read only
report, I found this reply by Ann Harrison
http://tech.groups.yahoo.com/group/firebird-support/message/79323 where one
guy said:

"I thought 'read committed' transaction is the best mode to use in
interactive (i.e. Read/Write) applications ?"

And Ann replied:

"Read-committed mode violates the Isolation and Consistency properties of
transactions. I don't know why anybody uses
it - at least not anybody who cares about consistent results. "

So my question is, in a multi-user environment where data will need to read
and write data, should I be using "Read-Write Table Stability" instead of
"Read Committed"?

Any tips appreciated.

Thanks,
Mike