Subject Re: [firebird-support] Firebird and transactions question
Author Thomas Steinmaurer
> I friend of mine recently told me that you should do everything in
> Firebird in the context of a transaction. If you are only
> inserting/updating/deleting one record then surely you don't need a
> transaction. Or if you only do one DDL change then surely you don't need
> a transaction? I can understand if your transaction involves multiple
> records or multiple DDL changes.

Every client request (DDL, DML) is in context of a transaction. If you
haven't started an explicit transaction up-front, your client access
layer usually creates an implicit for you then.

Transactions are a crucial part in the Firebird universe. Treat them as
your friend and not as your enemy. Research, learn and breath them.

If you get a chance, join one of the next stops of:

According to the session descriptions and the people involved, worth
every penny.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.