Hi, I assume you used Peer::doSelect or something similar. So all objects are hydrated and if you have related object each call to them causes another sql query.
The nice thing with Propel is, that you can choose if you want to use automatic hydrating or if you want to do it manually. You can even choose to use custom sql (bybassing Propel at all) or using the Criteria interface. I always use Propel until I am experiencing performane issues and recode this pieces manually. I am very happy with this approach and I can recommend it to everyone. Robert http://www.cusoon.at On Mar 3, 1:03 pm, Silvain Piree <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
