> in perl: [very simple code] > > my $stime = time; > > prepare(); > execute(); > fetchall_array_ref(); > > my $etime = time; > > my $ftime = $etime - $stime; > > print "Your query took $ftime seconds\n"; > > stupid filter: sql, query, mysql, db, table, select, insert, update, delete, > join, create, left join, optimize, describe, show, status, grant > > cheers, lms > > >Hi there, > >Lets say i do the following query: > > > >mysql > select something from some_table; > > > >Then i will get the results , how many rows and how much time it took to > >perform the query. > >My question is how can i get the time it took for perform the query. > >I want that cuz i would like to put in a web page something like "Your > query > >took 0.04 seconds".
His question seemed to indicate the time was in sub seconds (as most queries are). If so then (and you are indeed using perl) then use Time::HiRes which is a higher resolution timer. -Lance --------------------------------------------------------------------- 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