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
-~----------~----~----~----~------~----~------~--~---

Reply via email to