Subject Readcomitted ReadOnly Transaction - Commit or Rollback?
Author Ralf Jansen
Hi,

when ending a ReadCommited ReadOnly Transaction and releasing resources what's considered Best Practice? Commit or Rollback. And if someone can elaborate and why it would be welcome.

Some Background to the question. I'm trying to optimize write Performance on the used storage subsystem. Firebird embedded 2.5.2 is used in a Windows .Net Application and Database files are located on a NAS.
When monitoring the system via the Windows PerformanceCounters i see writes to the database. In my test environment when having around 400 Readonly Transactions per second (and nothing else) it sums up to around 2.5MB per second.
Looking at Mon$Transactions at the same time shows 0 Page_Writes/Page_Marks. I'm not sure if I can trust that values as I'm looking at the table inside the readonly transactions before commit/rollback since the values would be gone afterwards.
The only thing I can think of that gets written are the transaction Counters. But that shouldn't be that much?

Best Regards
Ralf