Re: How do I time a query from the SQL Editor?

for times >> 1 second this seems to be a sufficient solution. Is there a way to get a finer resolution (down to a fraction?)? My sql editor shows current to the second. Its fractions are always .000 even if I cast to datetime year to fraction. Thanks again for the response so far. >>>>> "Sandy" == Sandy Speirs <Sandy_Speirs@css.mot.com> writes: Sandy> Thomas, I normally time queries by doing Sandy> select unique(current) from systables; Sandy> < some select statements > Sandy> select unique(current) from systables; Sandy> This gives you a neat display of start and end times. Sandy> HTH Sandy >> ---------- From: thomas@koz.com[SMTP:thomas@koz.com] Reply To: >> thomas@koz.com Sent: Friday, November 21, 1997 8:25 AM To: >> informix-list@rmy.emory.edu Subject: How do I time a query from >> the SQL Editor? >> >> >> Hello Family, (I like this intro :) ) >> >> Is there a way from the SQL Editor to get the time it takes to >> do a query? Im using: >> >> INFORMIX-Universal Server Version 9.12.UC2X1 on Solaris 2.5 and >> SQLEditor 2.00.TC1 on Win95. >> >> It would help me in my quest to optimize my code. >> >> Thanks. >> >> -- Thomas Tatum thomas@rtp.koz.com 919-489-5662 x32 >> 919-602-6521 >> >> >> -- Thomas Tatum thomas@rtp.koz.com 919-489-5662 x32 919-602-6521