List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:December 20 2002 8:04pm
Subject:Re: time of query
View as plain text  
In the last episode (Dec 20), Vitali Malicky said:
> 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?

The mysql shell does that manually, by starting a timer before running
the query, then printing the elapsed time.  I'm sure Perl has a similar
timer module you could use.

	Dan Nelson
time of queryVitali Malicky20 Dec
  • Re: time of queryDan Nelson20 Dec
  • Re: time of queryBill Lovett20 Dec
  • Re: time of queryVitali Malicky24 Dec