Forums Register Login

Query Execution Time.

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
S.o.p(" starting at : "+timestamp);
executeQuery();
S.o.p(" ending at : "+timestamp);
+Pie Number of slices to send: Send
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!
I don't always make ads but when I do they're tiny
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 3001 times.
Similar Threads
URGENT !!! how do i find query string in prepared stmt ???
Fetching nK records in batch from client side?
How to count the execution time of my select statement?
time of Query Execution in Oracle ?
SQL Server 2005 Express error logs
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 05:45:36.