From: Dan Nelson
Date: December 20 2002 8:04pm
Subject: Re: time of query
List-Archive: http://lists.mysql.com/mysql/128114
Message-Id: <20021220200436.GB89493@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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
	dnelson@stripped