Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to count the execution time of my select statement?

 
lijun wang
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to count the execution time of my select statement?
Thanks.
 
Rajan Chinna
Ranch Hand
Posts: 320
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If its in query analyzer u can find that at the right bottom side.
If its in java application, capture time before and after statement execution and find the time difference.
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Within the next week or so I hope to release a new version of jamon that allows you to monitor a connection and that will automatically track jamon stats (hits/avg/min/max and more) for every query and other aspects of jdbc such as connection times etc. To enable this you will simply have to do the following. Sign up for the jamon release notices at sourcforge (see link below) and you will be notified when it comes out. I will post on this forum again when it is released too.

The code will be as simple as the following to monitor jdbc (Connections/PreparedStatements/Statements/ResultSets etc, sql, and exceptions thrown.)

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic