Hello dear Django community,
I'm currently working on an application which loads and finally
displays large table data, which, internally, is spread over several
SQL tables. More precisely, there's a table "devices" which is
supposed to be displayed together with some information attached to it
(stored other tables).
My template looks similar to the following:
{% for device in devices %}
<tr>
<td>{{ device.column1 }}</td>
<td>{{ device.foreign_key.foreign_column }}</td>
<td>{{ device.foreign_key.foreign_foreign_key.foreign_foreign_column }}
</td>
[…]
</tr>
{% endfor %}
Now, the only thing I did in my Python code was:
devices = Device.objects.filter(...)
Doesn't that mean that Django has to load all the foreign data when it
is requested for the first time, i.e. in the template? Doesn't that in
turn mean that Django queries the database at least once for every
single row I want to display? The average 3-5 seconds that a page
request takes seem to prove that. (Seriously, I'm not doing anything
else than loading all those devices (~100-200) and running everything
through that template.)
Finally, is there a better to achieve these kinds of joins?
Thanks in advance!
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@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.
