> (...)
> I use stored procedures for complex inserts, deletes and updates where I
> need to check many stuff before I commit the operation. Each procedure
> return code number and message with one select as a result. I see no problem
> using SP this way.
Just wanted to second that. We use SP as well - wherever applicable.
Though in general, SP don't seem to be used as much with MySQL for all
reasons above, and then MySQL just "recently" supported them and I
doubt that many shared webhosting shops allow you to use SP already.
Somewhat related -- due to certain limitations, we have also been
using the Mysql proxy and LUA to perform simple tasks that would be
currently more painful to implement in a SP. But that's not applicable
for shared webhosting either.
Till
没有评论:
发表评论