Re: Time measurements

On 28 Jan 98 at 10:03, Georg Winkens wrote: > 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. You must ensure that USEOSTIME is switched on in your onconfig file. > 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. Try running your sql scripts using timex. HTH. -- /Ciao, \\Billy / \\Group Managing Director, The West Solutions Group: http://www.west.co.za / Chairman, South African Informix User Group: http://www.west.co.za/~saiug \\ Informix FAQ @ http://www.iiug.org/techinfo/faq/faq_top.html / Drivel @ http://www.west.co.za/tasteless/ \\________________________________________________________________________________________________