Hi Luc,
you got it: Transactions are only used when changing data, not reading it. If you only read data, you need not concern yourself with transactions.
However, there are side effects:
When using sqlite, you must sqlite3_finalize() all statements before ending a transaction (commit), or else you get an error. At least, this is what i experienced.
When using other database systems, select-Statements can also implicitly start a transactions, depending on the database.
Martin
Luc Vandal schrieb:
Hi!
That's probably a no brainer for you guys but are transactions only useful for when we're writting or updating the database? Buy using transactions when fetching data, do I improve anything or I shouldn't do that?
Thanks!
Luc
