Re: HELP: Long (lasting) transactions?

In article <3meo0j$nnh@jac.zko.dec.com>, swonger@kwalty.enet.dec.com (Roy F. Swonger) writes: >In general, I'd think that such long transactions would present a problem for >recoverability in any database system. It's sort of like backing up your >system disks; if you only do it every few days, can you really afford to lose >a few days' worth of data? With transactions, if some catastrophe occurs three >days into a transaction, can you really afford to have those three days of >activity be completely lost? I had thought that the long lasting transaction was read-only. If that's true, then maybe the whole transaction doesn't have to be repeated. That said, several days is a lot longer than I've ever (intentionally) left a transaction going. (These are my opinions only, not a comment or commitment by my client or employer) David Cressey Quantum, Shrewsbury, MA