Re: time of query

2002-12-24 Thread Vitali Malicky
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; ma

Re: time of query

2002-12-20 Thread 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

Re: time of query

2002-12-20 Thread Dan Nelson
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? >

time of query

2002-12-20 Thread Vitali Malicky
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.