List:General Discussion« Previous MessageNext Message »
From:Vitali Malicky Date:December 24 2002 5:04pm
Subject:Re: time of query
View as plain text  
Hi, ladies and gentleman!

Well, I have solved my problem, though it was not actually a problem,
I just wanted things to look cool :)

1. Download "Time::HiRes" perl module
http://search.cpan.org/CPAN/authors/id/J/JH/JHI/Time-HiRes-1.39.tar.gz

2. Install it: "perl Makefile.PL; make; make test; make install"

3. Include the module into your script:
use Time::HiRes qw( usleep ualarm gettimeofday tv_interval );

I only need the gettimeofday(); function, so my "use" line looks like this:
use Time::HiRes qw(gettimeofday);

4. In you script type:

#before the query...
$start = gettimeofday();

your SQL query here...

#and after the query is executed...
$end = gettimeofday();

printf("Your SQL query took <strong>%.6f</strong> sec.<br>\n", $end -
$start);

That's all, thanks to all who replied!


> 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 <mysql-thread128119@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-vitali=altron.kharkov.ua@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>




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