Re: HELP: Long (lasting) transactions?

In article <3makt8$sv@hustle.rahul.net>, billb@lore.kla.com (Bill Baloglu) writes: |>We are designing a C++ application which will initially |>run on ORACLE (and subsequently may run on Sybase and |>Informix). In this application, there will be scenarios |>under which a database transaction may be open for a few |>days. : |>Is there anyone who may wish to caution us on |>any potential problems that such long lasting |>transcations would present. 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? Roy -- -------- Roy F. Swonger Oracle Rdb Software Quality Engineering swonger@nova.enet.dec.com The opinions expressed in my notes are solely my own and not those of my employer. --------