RE: How do I time a query from the SQL Editor?
Thomas,
I normally time queries by doing
select unique(current) from systables;
< some select statements >
select unique(current) from systables;
This gives you a neat display of start and end times.
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
}
}
}