Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Measuring query execution time

 
Stefan Krompass
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

how can I measure the execution time of a query in the database (DB2)? Something like
won't work (IMHO) since network time is included.

Stefan
 
Chetan Lakshmeshwar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Stefan Krompass:
Hi,

how can I measure the execution time of a query in the database (DB2)? Something like
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
author & internet detective
Marshal
Posts: 34401
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic