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:
http://www.firebirdsql.org/en/firebird-conference-tour-2013/
According to the session descriptions and the people involved, worth
every penny.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
