sql running time

Posted in 2004

CHEN BIN — Thu, 09 Sep 2004 07:29:40 — source: IIUG Forums & Mailing Lists

hellow all: My question,can I have a simple way to test sql executed time? I know that it can carry out by programming,but it is a common job,I don't know if there is a tool to do in IDS. For example, in dbaccess, I can some statement to get the total time. thanks in advance.

↪ replying to CHEN BIN

Jonathan Leffler — Thu, 09 Sep 2004 20:08:18 — source: IIUG Forums & Mailing Lists

SQLCMD from the IIUG Software Archive has a benchmark mode that does this. Command line: sqlcmd -B Statement: benchmark [on|off|push|pop] -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" forum.subscriber@iiug.org wrote on 09/09/2004 12:29:40 AM: > hellow all: > My question,can I have a simple way to test sql executed time? > I know that it can carry out by programming,but it is a common job,I don't > know if there is a tool to do in IDS. For example, in dbaccess, I > can some statement to get the total time. > thanks in advance. >

Glossary

dbaccess