aspose file tools
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
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: 42564
    
  31
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: 3740
    
  10

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: http://aspose.com/file-tools
 
subject: Query Execution Time.