Bug #32053 | Stored procedures/functions are slow | ||
---|---|---|---|
Submitted: | 2 Nov 2007 12:37 | Modified: | 8 Nov 2007 3:16 |
Reporter: | Yurij Zagrebnoy | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S4 (Feature request) |
Version: | 5.0.45 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | functions, procedures, slow, stored |
[2 Nov 2007 12:37]
Yurij Zagrebnoy
[7 Nov 2007 5:29]
Valeriy Kravchuk
Thank you for a feature request. Please, check if UDFs (written in C) that are in MySQL for ages can help in your case. They should give you PHP/native performance for computation. Please, read http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html for the details.
[7 Nov 2007 13:44]
Yurij Zagrebnoy
Thank you for your response, I'm quite familiar with UDFs but it's not always convenient or even possible to use them, I have many examles proving this. It would be really valuable to have stored procedures' execution speed increased.
[8 Nov 2007 3:16]
Valeriy Kravchuk
It's hard to disagree with thisfeature request. Surely it would be nice to have stored procedures running faster. We may get Java/Lua/PHP/.Net stored procedures eventually, or just improved current implementation. I can not tell you for sure how and when it will be implemented, though.