-----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Tuesday, February 23, 2016 10:14 AM To: [email protected] Subject: Re: [firebird-support] firebird and transaction behaviour questions
23.02.2016 16:03, 'Zoran' [email protected] [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 :)
