File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Query Execution Time. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Query Execution Time." Watch "Query Execution Time." New topic

Query Execution Time.

pankaj semwal
Ranch Hand

Joined: Oct 07, 2008
Posts: 303
Hi List[],
How i can find the execution time of query in jdbc.i.e
IF suppose i fire select * from emp query then how we can find that how much time it takes to get data from table.

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46337
Varies from database to database. In MySQL running from the command line, it says, "Query successful, 874658345983749 lines, 3.01 seconds."

Or something rather like that.
pankaj semwal
Ranch Hand

Joined: Oct 07, 2008
Posts: 303
But i want to know how we can know the execution time of query.

Is there any code for it to find out the execution time of query.
Please tell me.
gopinathang ganapathy

Joined: Nov 22, 2008
Posts: 4
S.o.p(" starting at : "+timestamp);
S.o.p(" ending at : "+timestamp);
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

Keep in mind there's no such thing as a static execution time of a query. Query times can vary depending on the data in your system. If you have no data, for example, queries will be fast!

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Query Execution Time.
It's not a secret anymore!