RE: transaction times - need help

Thanks. I was hoping for something a little more at the time of the event though. Anyone? Thanks, Dianne -----Original Message----- From: Sujit.Pal@BankAmerica.com [mailto:Sujit.Pal@BankAmerica.com] Sent: Friday, February 12, 1999 1:37 PM To: dianne.pendleton@autodesk.com Cc: informix-list@iiug.org Subject: 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