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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- 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
