Time measurements

Posted in 1998

Georg Winkens — Wed, 28 Jan 1998 10:03:23 +0100 — source: Informix-list mailing list archive (1991-1998)

Does anybody have experience in doing time measurements for SQL queries that take less than 1 sec.? I have a SQL script with a sequence of select statements and I would like to know the elapsed time for each of the statements. I tried to use Select CURRENT .. before and after each statement, but it seems that it does not give any figures for the milli seconds fraction. Another question: Where do I get information about the CPU time that Informix used for one specific session? onstat provides me only with the total CPU time used by all processes. Thanks for your help, Georg P.S: We are using Online 7.23 on HP.