Re: AW: Performance

2011-12-06 Thread Felipe Morales
. . . . . . . . . . . . . . >> >> ** >> >> Ing. Patrick Szabo >> XSLT Developer >> >> LexisNexis >> Marxergasse 25, 1030 Wien >> >> patrick.sz...@lexisnexis.at >> >> Tel.: 00431 534521573 >> >> Fax: +43 (1) 534 52 - 14

Re: AW: Performance

2011-12-06 Thread Felipe Morales
glegroups.com [mailto:django-users@googlegroups.com] > *Im Auftrag von *Szabo, Patrick (LNG-VIE) > *Gesendet:* Dienstag, 06. Dezember 2011 08:29 > *An:* django-users@googlegroups.com > *Betreff:* AW: AW: Performance > > ** ** > > Thank you, i could cut my queries in half which b

AW: AW: Performance

2011-12-05 Thread Szabo, Patrick (LNG-VIE)
G-VIE) Gesendet: Dienstag, 06. Dezember 2011 08:29 An: django-users@googlegroups.com Betreff: AW: AW: Performance Thank you, i could cut my queries in half which brings almost a second J Unfortunately the function seems to effect the results. If I run the query with select_related() I get 151 ob

AW: AW: Performance

2011-12-05 Thread Szabo, Patrick (LNG-VIE)
: django-users@googlegroups.com [mailto:django-users@googlegroups.com] Im Auftrag von Felipe Morales Gesendet: Montag, 05. Dezember 2011 17:50 An: django-users@googlegroups.com Betreff: Re: AW: Performance Patrick, try to use select_related() method instead of only filter() when you get a list

AW: AW: Performance

2011-12-05 Thread Szabo, Patrick (LNG-VIE)
- Von: django-users@googlegroups.com [mailto:django-users@googlegroups.com] Im Auftrag von Tim Sawyer Gesendet: Montag, 05. Dezember 2011 18:07 An: django-users@googlegroups.com Betreff: Re: AW: Performance http://pypi.python.org/pypi/django-debug-toolbar will show the number of queries, tim

Re: AW: Performance

2011-12-05 Thread Tim Sawyer
http://pypi.python.org/pypi/django-debug-toolbar will show the number of queries, time taken to query, and allow you to see the stack trace for the code that caused the query to be executed. Hope that helps, Tim. > On Dec 5, 2011, at 3:18 AM, Szabo, Patrick (LNG-VIE) wrote: > >> Okay that toolba

Re: AW: Performance

2011-12-05 Thread Felipe Morales
Patrick, try to use select_related() method instead of only filter() when you get a list of elements, e.g. : queryset = Model.objects.filter().select_related() by this way you'll get only one query instead 800 good luck! Felipe 2011/12/5 Nikolas Stevenson-Molnar > It would help to know a li

Re: AW: Performance

2011-12-05 Thread Nikolas Stevenson-Molnar
It would help to know a little more about your code here. Could you give some examples? _NIk On Dec 5, 2011, at 3:18 AM, Szabo, Patrick (LNG-VIE) wrote: > Okay that toolbar is really useful and also looks kind of nice J…Thanks for > that. > I’ve already found the problem….somehow my app trigge

AW: Performance

2011-12-05 Thread Szabo, Patrick (LNG-VIE)
Okay that toolbar is really useful and also looks kind of nice J...Thanks for that. I've already found the problemsomehow my app triggers 800 queries just for a simple page. Can I somehow find out which part of my code is causing those queries ?! patrick Von: django-users@googlegroup

AW: Performance

2011-12-05 Thread Szabo, Patrick (LNG-VIE)
Thx a lot i will check this out ! Von: django-users@googlegroups.com [mailto:django-users@googlegroups.com] Im Auftrag von Nikolas Stevenson-Molnar Gesendet: Montag, 05. Dezember 2011 08:14 An: Nikolas Stevenson-Molnar Cc: django-users@googlegroups.com Betreff: Re: Performance A bit more se