Re: Prepared statements versus stored procedures

There is no external caching for executing a CALL; the runtime executes the procedure afresh each time.  If it were any different that would have to be documented.

The fact that store procedures do not return result sets - and are procedures - and prepared statements are not procedures and can return result sets makes any kind of direct comparison pretty meaningless in practice.  They do different things and solve different problems.  Know what the problem you are trying to solve is and which of the two are plausible options will make itself clear.

David J.