#26 (doc) transactional monitoring

open
None
1
2011-02-13
2011-01-26
Michael Justin
No

http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-mon

"A snapshot is created the first time any of the monitoring tables is being selected from in the given transaction and it is preserved until the transaction ends, in order that multiple-table queries (e.g., master-detail ones) will always return a consistent view of the data. "

Discussion

  • Michael Justin
    Michael Justin
    2011-02-13

    • priority: 5 --> 1
     
  • Michael Justin
    Michael Justin
    2011-02-13

    if autoCommit is true, every select will start a new tx and not see consistent data