Hi Silvain: Are you hidrating all records in objects?. It's not a good practice with large queries. For larges queries write a model method, when this method returns a hash or recordset.
2008/3/3, Pedro Casado <[EMAIL PROTECTED]>: > > Did you change these lines? > > define('SF_ENVIRONMENT', 'dev'); > define('SF_DEBUG', 1); > > for > > define('SF_ENVIRONMENT', 'prod'); > define('SF_DEBUG', 0); > > Maybe its slow because you are running in dev... > > > Pedro Casado > > > On Mon, Mar 3, 2008 at 2:20 PM, Nicolas Perriault <[EMAIL PROTECTED]> > wrote: > > > > > On Mon, Mar 3, 2008 at 1:03 PM, Silvain Piree <[EMAIL PROTECTED]> wrote: > > > > > 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. > > > > To me and from my own experiences, running big sql-intensive batches > > using a db abstraction layer (I didn't say an ORM) is not a good idea > > from a performances point of view. I would vote for some manually > > written SQL queries in such a case while dreaming about a decent mysql > > dedicated and optimized ORM. > > > > ++ > > > > -- > > Nicolas Perriault > > http://prendreuncafe.com/blog > > GSM: 06.60.92.08.67 > > > > > > > > > -- > Atenciosamente, > > Pedro Casado > > > -- Boris Duin Celular: 0416-8136373 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---