Hi, i'm evaluating symfony for developing a new system. Until now symfony has looked very promising, but last week i did some performance tests on Propel, and the results were really disappointing.
For online applications the performance of Propel is acceptable (not good, but acceptable). But for batch applications, that in our case need to process > 10.000 records, the performance was terrible. In one extreme case a query on 10.000 records with a join on four tables took more than 700 seconds to complete for propel; the PDO version took 0.73 seconds (including reading the results into an array) .... On average Propel was about 7 to 10 times slower than any other solution i tested. And yes ... i tried Propel 1.3 but the improvements were marginal and in some case even made it worse. And yes ... i also tried using the pager object which did help but not a lot. And 10.000 records isn't that much ... we have queries on tables a lot bigger than that. So, my question to you out there: what are your experiences with Propel? Any way to boost the performance of Propel? I don't understand how this thing can perform so bad. Would be a pity if we couldn't choose symfony because of propel. Silvain --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
