-----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Tuesday, February 23, 2016 9:36 AM To: [email protected] Subject: Re: [firebird-support] firebird and transaction behaviour questions
23.02.2016 15:02, [email protected] [firebird-support] wrote: >> A friend of mine said that everything in firebird MUST be done inside a transaction. > That's true, but according to ODBC specs driver should start transaction automatically as needed. >> Is this the case if you are doing reads only? > Yes. Why would you use transaction for select statements? >> Is this the case if you are only inserting, updating or deleting ONE record at a time? > Yes. In this case transaction can be committed automatically according to ODBC "autocommit" attribute.. 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. >> I can understand if you are writing changes effecting multiple records. >> Do you have to do transactions while doing DDL changes? > Yes. See above.
