Hi, I think it is better to implement this measurment in your application - thus you'll have an estimate of the time needed to execute your procedures including the mysql calls.
Otherwise you can use the BENCHMARK MySQL function http://mysql.online.bg/doc/mysql/en/Information_functions.html for example mysql> select benchmark(1000,procedure_name); +--------------------------------------------------+ | benchmark(1000,procedure_name) | +--------------------------------------------------+ | 0 | +--------------------------------------------------+ 1 row in set (0.15 sec) the average time to execute the procedure will be 0.15/1000 = 0.00015 seconds HTH -- Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ On Tuesday 12 October 2004 19:47, Thomas Schager wrote: > Hi, > > I need to messure the time needs of my procedures in MySQL. How can I > reach a messurement of time intervals that include milliseconds, written > in MySQL SQL statements? > > > Thanks for any ideas, > > Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
