Accessing query time via DBI / DBD::MySQL

[Graham Drabble]

When you run a query in MySQL the last row returned is of the form:

4 rows in set (0.20 sec)

How can I get access to that time when using DBI / DBD::MySQL ?

 

[Eric Schwartz]

When you run a query in MySQL the last row returned is of the form:

4 rows in set (0.20 sec)

That's not actually part of the rows that are returned; it's something
the client prints out.

How can I get access to that time when using DBI / DBD::MySQL ?

perldoc -f time

-=ERic

 

[Graham Drabble]

That's not actually part of the rows that are returned; it's
something the client prints out.

Thanks, I hadn't realised that.

perldoc -f time

I had considered doing that, I was simply hoping there was something
built in since the figure above goes to .01 of a second and to do that
with time calls either side of the statement requires Time::HiRes.