CODEWITHSUNDEEP
mysqlpdo
Brad
Brad

Reputation: 163262

PDO statement execution time

How can I determine the time a statement took to execute on the database server with PDO?

I am using MySQL. Most MySQL client utilities seem to be able to show how long a query ran on the server, irrespective of the total time which includes the transfer of the result over the network. This leads me to believe that the native MySQL API offers this information somewhere. Is it exposed in PDO? If so, how can I get to it?

Note: I have found a MySQL query method, but would prefer not to execute more statements just for this if the execution time is already kept track of somewhere else. If it isn't, then I will fall back on this method.

Upvotes: 4

Views: 2794

Answers (1)

Brad
Brad

Reputation: 163262

It seems that there is no way to do this at the PDO layer. In retrospect, this makes quite a bit of sense, since PDO is abstracting all of the DB-specific features away.

Upvotes: 1

Related Questions