Hi, what are your thoughts on the benefits to be had from stored procs?
Im from an MS SQL background, and the benefits there are quite clear. But several places I read about MySQL Stored Procs and they warn ‘there is an overhead of stored procs because some of the processing moves from the client to the server’.
I dont really understand this.
What overhead does using a precompiled stored procs involve?
Is it referring to the overhead of dynamically building the query, and if so why would this be an issue other than the first time its run (ie compiled)?
For the purposes of my question, pleae ignore the benefits of stored procs caused by reduced network traffic and all security issues. Im aware stored procs can often provoke a religious debate )
Im talking purely about the caching of compiled batches, which is the performance benefit Im hoping to gain on my heavily used website