Re: time of query

[Bill Lovett]

I don't think MySQL can give you back the execution time via DBI, but you might be able to calculate something similar from the Perl side by calculating how long the script runs overall. Here's a good thread from perlmonks about how to do it:

http://perlmonks.org/index.pl?node_id=35318

-bill

Vitali Malicky wrote:

Glad to greet you all, ladies and gentelmen!

I have written a dynamic web page in Perl to display some kind
of statistical information usefull for my company.

My question: how can I get the time which MySQL returns after the query?

For example: MySQL returns a line like this "870 rows in set (0.91 sec)"
after successful query
How can I get the value 0.91 and save it in my Perl script, is at all
itpossible?

Hope I made myself clear.

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php