The obvious way to do this would be to get the time before and after the execution and then make a simple diff (after - before) I guess that is how the mysql client does it (butI'm not sure) I do not think that mysql itself provides this information..
how to get the time in Perl/DBD I do not know. but in java it would be long tb = System.currentTimeMillis(); // do the sql-statement long diff = System.currentTimeMillis() - tb; ----- Original Message ----- From: "Gordan Bobic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 12:49 PM Subject: Query Execution Time Perl/DBD > Hi. > > How do I get the query execution time from Perl/DBD? MySQL client returns > this in the console window. Is this value available through the Perl DBD > interface? > > Thanks. > > Gordan > > --------------------------------------------------------------------- > 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