Subject RE: [firebird-support] firebird and transaction behaviour questions
Author Zoran
-----Original Message-----
Sent: Tuesday, February 23, 2016 10:14 AM
Subject: Re: [firebird-support] firebird and transaction behaviour questions

23.02.2016 16:03, 'Zoran' zoran565@... [firebird-support] wrote:
>> Why would you use transaction for select statements?

> For data consistency. People like consistent data in reports.

If other clients are using transactions properly (when updating multiple
rows), database should be in a stable state.

Using transactions when not needed (in my opinion - and I am no expert in
Firebird) just add an overhead to the server.

>> No. For ONE row at the time you don't need a transaction. If you are
>> changing multiple rows, then you do need to wrap it into transaction.

> ODBC standard writers had different opinion.

I don't use ODBC. Probably ODBC writers have a good reason :)