Hi, All,
I have a question about ForeignKey in Django. Say, I have a model like
this,
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
class test(models.Model):
no=models.CharField(_('No.'),max_length=6,.....)
nat=models.ForeignKey(Code,verbose_name=_
('Nationality'),related_name='b_nat',
limit_choices_to=
{'cat':'1','status':'Y'})
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Say, there are 3,000 records in postgreql database. When I try to list
all objects in one page, the sql queries will be pretty high, like
more than 3000 times queries in backend.
Then, I just installed debug-toolbar, and try to find the reason of
why so many sql queries executed in backend. Finally, I found that
each record will trigger another sql query if there is a ForeignKey
field. Because of this reason, my django application is really slow
on showing large records in one page, is this a performance issue in
Django and Postgresql?
Does every body know this issue and know how to solve it? Your any
suggestion or solution will be highly appreciated!
Regards,
Zeal
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
