Re: template speed
Nope, i'm using select_related(). On 23 сент, 04:32, "Michael Elsdoerfer" <[EMAIL PROTECTED]> wrote: > > {% ifequal newsitem.user.id 12 %} > > Just a guess, but is it possible that this requires a separate query for the > user for each item in object_list? > > Michael > > > -Original Message- > > From: django-users@googlegroups.com [mailto:[EMAIL PROTECTED] > > On Behalf Of [EMAIL PROTECTED] > > Sent: Saturday, September 22, 2007 2:25 PM > > To: Django users > > Subject: template speed > > > Hello. > > > I'm worrying about my django-app setted up on mod_python 3.3.1+apache > > 2.0.59 speed. > > I have this modelhttp://dpaste.com/20362/. On production server > > (Pentium D, 2Gb RAM) with all DEBUG turned off and StatsMiddleware > > from (http://code.djangoproject.com/wiki/PageStatsMiddlewareto get > > page generation time) i've tested two different templates (both > > rendered by object_list generic view): > > > First: > > {%for object in object_list%} > > {{object}} > > {%endfor%} > > > Gives about 0.013 - 0.023sec page generation time > > > Second more complicated (most of HTML code removed to improve > > reading): > > > {% for newsitem in object_list %} > > > {{ newsitem.title }} > > {{ newsitem.pdate|date:"j.m.Y" }} > > > {% ifequal newsitem.user.id 12 %} > > {{ newsitem.author }} | > > {% else %} > > {{ newsitem.user.username }} | > > {% endifequal %} > > > > > {{ newsitem.brief|striptags }} > > > > > > {% endfor %} > > > This gives ten times more: 0.1-0.14 secs, in both cases SQL time was > > like 0.006-0.008 secs. > > Is it normal, that this very simple code take ten times more > > processing? You see that i don't make any manytomany relationship > > lookups neither some heavy func calls. > > > Plus to this, ab testing (ab -n100 -c 15) gives about 5 req/sec which > > is pretty slow, i think. > > > Regards, Dmitry. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-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/django-users?hl=en -~--~~~~--~~--~--~---
RE: template speed
> {% ifequal newsitem.user.id 12 %} Just a guess, but is it possible that this requires a separate query for the user for each item in object_list? Michael > -Original Message- > From: django-users@googlegroups.com [mailto:[EMAIL PROTECTED] > On Behalf Of [EMAIL PROTECTED] > Sent: Saturday, September 22, 2007 2:25 PM > To: Django users > Subject: template speed > > > Hello. > > I'm worrying about my django-app setted up on mod_python 3.3.1+apache > 2.0.59 speed. > I have this model http://dpaste.com/20362/. On production server > (Pentium D, 2Gb RAM) with all DEBUG turned off and StatsMiddleware > from (http://code.djangoproject.com/wiki/PageStatsMiddleware to get > page generation time) i've tested two different templates (both > rendered by object_list generic view): > > First: > {%for object in object_list%} > {{object}} > {%endfor%} > > Gives about 0.013 - 0.023sec page generation time > > Second more complicated (most of HTML code removed to improve > reading): > > {% for newsitem in object_list %} > > {{ newsitem.title }} > {{ newsitem.pdate|date:"j.m.Y" }} > > {% ifequal newsitem.user.id 12 %} > {{ newsitem.author }} | > {% else %} > {{ newsitem.user.username }} | > {% endifequal %} > > > {{ newsitem.brief|striptags }} > > > {% endfor %} > > This gives ten times more: 0.1-0.14 secs, in both cases SQL time was > like 0.006-0.008 secs. > Is it normal, that this very simple code take ten times more > processing? You see that i don't make any manytomany relationship > lookups neither some heavy func calls. > > Plus to this, ab testing (ab -n100 -c 15) gives about 5 req/sec which > is pretty slow, i think. > > > Regards, Dmitry. > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-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/django-users?hl=en -~--~~~~--~~--~--~---
template speed
Hello. I'm worrying about my django-app setted up on mod_python 3.3.1+apache 2.0.59 speed. I have this model http://dpaste.com/20362/. On production server (Pentium D, 2Gb RAM) with all DEBUG turned off and StatsMiddleware from (http://code.djangoproject.com/wiki/PageStatsMiddleware to get page generation time) i've tested two different templates (both rendered by object_list generic view): First: {%for object in object_list%} {{object}} {%endfor%} Gives about 0.013 - 0.023sec page generation time Second more complicated (most of HTML code removed to improve reading): {% for newsitem in object_list %} {{ newsitem.title }} {{ newsitem.pdate|date:"j.m.Y" }} {% ifequal newsitem.user.id 12 %} {{ newsitem.author }} | {% else %} {{ newsitem.user.username }} | {% endifequal %} {{ newsitem.brief|striptags }} {% endfor %} This gives ten times more: 0.1-0.14 secs, in both cases SQL time was like 0.006-0.008 secs. Is it normal, that this very simple code take ten times more processing? You see that i don't make any manytomany relationship lookups neither some heavy func calls. Plus to this, ab testing (ab -n100 -c 15) gives about 5 req/sec which is pretty slow, i think. Regards, Dmitry. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-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/django-users?hl=en -~--~~~~--~~--~--~---