What version of symfony are you using? I believe this was an issue in  
sfDoctrinePager that has been addressed in the latest release.

--

Kris Wallsmith | Release Manager
[email protected]
Portland, Oregon USA

http://twitter.com/kriswallsmith

On Nov 14, 2009, at 1:30 AM, Nicolas Perriault wrote:

>
> On Sat, Nov 14, 2009 at 5:03 AM, ever.zet <[email protected]> wrote:
>>
>> Turned ON output escaping in sf 1.3 causes huge amount of extra  
>> queries in generated admin on top of nested-set enabled schema.
>>
>> Steps to reproduce problem:
>> 1. Create sf 1.3 project with Doctrine enabled
>> 2. Write scheme with nested-set behavior
>> 3. generate-admin for this scheme
>> 4. Open generated admin in DEV enviroment (with active dev  
>> toolbar). Now you must see that db inspector shows 3-4 queries in  
>> list of records.
>> 5. Add new record to database
>> 6. Now queries count in list is 4-5. 1 extra query. Open db  
>> inspector & you will see that there is 2 identical queries now.
>>
>> That bug is simple to reproduce, but there is other bugs with  
>> output escaping & doctrine nested-set. Every call to tree functions  
>> in templates runs 2 identical queries.
>>
>> This bugs shows only if output escaping is ON. If we turn output  
>> escaping OFF in settings.yml - no extra queries in fired.
>
> Could you create a ticket please? http://trac.symfony-project.org/newticket
>
> Thanks
>
> -- 
> Nicolas Perriault
> http://prendreuncafe.com - http://symfonians.net
> Mobile: +33 660 92 08 67
>
> >


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/symfony-devs?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to