Silver Posted September 11, 2011 Share Posted September 11, 2011 Hi Larry, On page 189, first note, you ran a few benchmarks and found stored procedures to be running significantly faster than the literal queries. Would you please share with us details of what you have done to enable us do it ourselves? Link to comment Share on other sites More sharing options...
Larry Posted September 12, 2011 Share Posted September 12, 2011 If I recall, I just ran the non-stored procedure queries and the stored procedure queries in the MySQL client and compared the execution times (I did this a few times). It's not the most scientific or thorough approach, but the SP ran much faster than the stand-alone queries. And you have to factor in that the SP had logic that the stand-alone queries did not, so putting those queries into a PHP script would have been even slower, as that script would have had to execute other queries and implement more logic. Link to comment Share on other sites More sharing options...
Recommended Posts