I'm glad that we might have found the problem and now we are trying to
resolve it.
The page is "edit"
The __unicode__ methode for TrProductsVersion is:
def __unicode__(self):
return u'%s (version: %s)' %(self.catalogueid,
self.prodversionid)
Where "catalogueid" (this object has one foreignkey, not in his unicode
methode) and "prodversionid"(this object has only one field) are foreign
keys and their __unicode__ methodes looks like this:
def __unicode__(self):
return u'%s' %self.productname
AND
def __unicode__(self):
return u'%s' %self.version
The __unicode__ methode for TLocation (this object has no foreign key) is:
def __unicode__(self):
return u'%s' %self.address
Finally the __unicode__ methode for TrRelatedService looks like this:
def __unicode__(self):
if self.clientservicename:
return u'%s' %(self.servicename)
else:
return u'%s (%s)' %(self.conid, self.solutionid)
This object has 5 foreign keys and 3 ManyToManyField relation.
When I look at the traceback from the django_debug_toolbar, there is 1852
queries in 20956ms, there is several repetition of the same calls. And
there is a lot of unnacessary calls. How can I optimise that? what can I do
about it? is there a way to overwrite the page for a given object. Because
I realise that my custom pages take less time to load.
Regards,
VB
2012/3/13 Javier Guerra Giraldez <jav...@guerrag.com>
> On Tue, Mar 13, 2012 at 9:55 AM, Phanounou <virginia.bel...@gmail.com>
> wrote:
> > I installed the django_debug_toolbar and I see that in the sql part I
> have
> > 1852 queries in 18228.00ms.
>
> great, so this is indeed the problem.
>
> which page is this?, the listing or the edit page? check the SQL
> code, which tables is it accessing?
>
> if this happens on the edit page, it might be when constructing the
> select elements. how does the __unicode__ of the related models look
> like?
>
> --
> Javier
>
> --
> 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
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
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
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
