Re: a very slow view, > 30secs to load

2007-03-30 Thread Milan Andric
On Mar 30, 1:08 am, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > > I'm confused. First you said it took 0.2 seconds, then you say it took > 47 seconds and then 3 seconds. Both of those numbers are bigger than > 0.2. I know this because I took advanced maths courses at university. > Yea, I

Re: a very slow view, > 30secs to load

2007-03-30 Thread Malcolm Tredinnick
On Fri, 2007-03-30 at 07:49 +, Milan Andric wrote: > > > On Mar 29, 8:31 pm, "Gary Wilson" <[EMAIL PROTECTED]> wrote: [...] > > When you say that the view is functioning very quickly, do you mean > > the time from request to page render? If so, the template is already > > getting run and

Re: a very slow view, > 30secs to load

2007-03-30 Thread Milan Andric
On Mar 29, 8:31 pm, "Gary Wilson" <[EMAIL PROTECTED]> wrote: > On Mar 29, 2:26 pm, "Milan Andric" <[EMAIL PROTECTED]> wrote: > > > But in the dev environment I can see pretty well that the view is > > functioning very quickly. So your hunch about the problem lying in > > the templates is

Re: a very slow view, > 30secs to load

2007-03-29 Thread [EMAIL PROTECTED]
Have you obtained the raw queries that are being run? If so, how long do they take to run against your db when you execute them yourself? This could be a database performance problem as opposed to a Django problem. On Mar 29, 11:31 pm, "Gary Wilson" <[EMAIL PROTECTED]> wrote: > On Mar 29, 2:26

Re: a very slow view, > 30secs to load

2007-03-29 Thread Gary Wilson
On Mar 29, 2:26 pm, "Milan Andric" <[EMAIL PROTECTED]> wrote: > But in the dev environment I can see pretty well that the view is > functioning very quickly. So your hunch about the problem lying in > the templates is probably right. If you aren't seeing the slowdown on your dev server, then

Re: a very slow view, > 30secs to load

2007-03-29 Thread Milan Andric
Great pointers, thanks! I will look at that. In the meantime I thought i would post my debug info. I used this snippet in my template to see what queries are happening. http://www.djangosnippets.org/snippets/93/ Looks like I'm making quite a few queries there, 71, but they still don't seem

Re: a very slow view, > 30secs to load

2007-03-29 Thread Joseph Heck
You can also whack together a quick Python logger to do the logging, which is what we've done in the past. Some example code for you: in the __init.py__ for the views (so the logger can be used anywhere) from django.conf import settings import logging # Grabs or creates a new logging object

Re: a very slow view, > 30secs to load

2007-03-29 Thread Graham Dumpleton
On Mar 30, 5:26 am, "Milan Andric" <[EMAIL PROTECTED]> wrote: > On Mar 28, 6:26 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> > wrote: > > > > > On Wed, 2007-03-28 at 19:59 +, Milan Andric wrote: > > > Hellow, > > > > Any advice you can offer on optimizing this view would be greatly > > >

Re: a very slow view, > 30secs to load

2007-03-29 Thread Milan Andric
On Mar 28, 6:26 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Wed, 2007-03-28 at 19:59 +, Milan Andric wrote: > > Hellow, > > > Any advice you can offer on optimizing this view would be greatly > > appreciated. > > >http://dpaste.com/7543/ > > > I was planning on trying to reduce the

Re: a very slow view, > 30secs to load

2007-03-28 Thread Malcolm Tredinnick
On Wed, 2007-03-28 at 19:59 +, Milan Andric wrote: > Hellow, > > Any advice you can offer on optimizing this view would be greatly > appreciated. > > http://dpaste.com/7543/ > > I was planning on trying to reduce the amount of data in pForms, the > list that is passed to the template.

a very slow view, > 30secs to load

2007-03-28 Thread Milan Andric
Hellow, Any advice you can offer on optimizing this view would be greatly appreciated. http://dpaste.com/7543/ I was planning on trying to reduce the amount of data in pForms, the list that is passed to the template. Since i'm saving 19 presentations into this list along with the forms, i'm