Measuring query execution time

[Stefan Krompass]

Hi,

how can I measure the execution time of a query in the database (DB2)? Something like

...
Statement s = con.createStatement();
long start = System.currentTimeMillis();
ResultSet rs = s.executeQuery(sql);
long end = System.currentTimeMillis();
...

won't work (IMHO) since network time is included.

Stefan

[Chetan Lakshmeshwar]

hi,

You may consider using IronEyeSQl.
Actually it has a wrapper over the jdbc driver you use.
Once configured it listens to all SQL activity on the stipulated port and gives you statistics graphically as well as text based reports.

Do take a look at

http://www.irongrid.com/

Regards,
chetan

[Jamie Robertson]

Originally posted by Stefan Krompass:
Hi,

how can I measure the execution time of a query in the database (DB2)? Something like

...
Statement s = con.createStatement();
long start = System.currentTimeMillis();
ResultSet rs = s.executeQuery(sql);
long end = System.currentTimeMillis();
...

won't work (IMHO) since network time is included.

Stefan

it's a good start, but as mentioned before a profiler would be the tool of choice for this situation

this post might even be better off in the performance forum, but that would be Bear or Jeanne's call.

Jamie

[Jeanne Boyarsky]

Stefan, You can also turn on database logging and have the database do the work. This is available from db2, Oracle and most other databases.

Jamie, Right now this is still on databases. If this turns into a discussion about profilers, we can move it to the performance forum.