[ciapug] MySQL Stored Procedures

[carl-olsen at mchsi.com]

How does Propel compare to MySQL Stored Procedures as far as performance (speed) goes?  I'm reading a book on MySQL Stored Procedures (MySQL Stored Procedure Programming, O'Reilly - March 2006, ISBN 0-596-10089-2) and it says MySQL Stored Procedures are much slower than PHP at doing some mathematical calculations.  They use a prime number generator as an example and show the speed for MySQL (19.5 seconds), Oracle (9.07 seconds), PHP (4.36 seconds), Perl (1.78 seconds), Java (0.34 seconds), VB.NET (0.36 seconds), and C (0.23 seconds).  I'm wondering how Propel compares to MySQL Stored Procedures when doing the create, read, update, and delete functions. I'm guessing Propel (PHP is what Propel is using) is faster on the same server (PHP code and MySQL running on the same machine).  Does anyone know?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/ciapug/attachments/20060802/44b32bee/attachment.html