Simen Haugen wrote: > I'm using mysql. > > I guess this is be triggered because I'm using InnoDB tables on this > database. > Still, I find it strange that I need to put select statements in a > transaction to get the updated data. When using select outside a > transaction, this means that you'll always want the updated data (or at > least I would think so). >
If you use a transactional database there isn't something like a select outside a transaction. Everything happens in a transaction even if you don't use explicit transaction handling. And it isn't strange. Think about a POS system. How would you do a financial report if your selected data changes constantly on every select within your transaction? If you want to read more about it, start here: http://en.wikipedia.org/wiki/Isolation_(computer_science) Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
