At 13:09 +0300 10/13/04, Dobromir Velev wrote:
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
Actually, that won't work. BENCHMARK() always returns 0. The time
you see is wallclock time determined by the mysql client program.
In your own applications, you need to measure the time yourself.
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
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
