Re: transaction times - need help

Dianne >>How can I see how much time a transaction takes in Informix? onlog lists the transaction id's (xid), and the times for each operation it does. If you check for each transaction and compute the difference between the timestamp for COMMIT and timestamp for BEGIN over a few transactions at an "average" time of day, you can get an estimate for a typical transaction time. HTH Sujit