aspose file tools*
The moose likes JDBC 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
Bookmark "Query Execution Time." Watch "Query Execution Time." New topic
Author

Query Execution Time.

pankaj semwal
Ranch Hand

Joined: Oct 07, 2008
Posts: 301
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.


Thanks
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39828
    
  28
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: 301
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
Greenhorn

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

Joined: Oct 23, 2005
Posts: 3716
    
    5

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!


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Query Execution Time.