Query Execution Time.

[pankaj semwal]

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]

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]

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]

S.o.p(" starting at : "+timestamp);
executeQuery();
S.o.p(" ending at : "+timestamp);

[Scott Selikoff]

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!