Re: [symfony-users] Re: sfWidgetFormChoice with custom query slower than sfWidgetFormPropelChoice generated by default

2010-09-06 Thread Hugo Chinchilla
On Mon, Sep 6, 2010 at 7:10 PM, Richtermeister wrote: > What happens if you run the query manually against the database? > Could be that you're doing a non-optimized join or so... > > Daniel No, the select is very simple, is a select over 3 columns from only one table. All the logic is fine and

[symfony-users] sfWidgetFormChoice with custom query slower than sfWidgetFormPropelChoice generated by default

2010-09-06 Thread Hugo Chinchilla
Hi, for my app's backend I have written a custom method to draw a select widget which was consuming a lot of memory to generate. The default form generated a select widget from the model populating full objects just to render an options list which only needs a PK and a string, so I wrote a method