Call to stored procedure is slow

[andrej marincic]

Hello.
I am using MySQL 5.0.13-rc-standard and i tryed much of new features like triggers, stored procedures and functions and views and i noticed that call to a stored function is much slower than plain sql statement that returns the same result. Okay you might say that call to a function takes some time ... but i have complex SQL subquery statement and this subquery statement is used in more than 1 query statements in my code and i thought if i wrap it in a stored function it should work faster and not about 3 times slower.

Execution of SQL it takes about 0.003 sec and call to a sql statemnts which calls this stored function it takes about 0.01 sec.

Maybe code in mysql 5 RC is not so optimized..and it will run faster in final release of MySql 5.

Does anybody have the same "problems" width speed of stored procedures?

best regards, Andrej