One tool that can be really helpful for helping with understanding
database activity is http://github.com/robhudson/django-debug-toolbar
It has an SQL panel that shows all the queries that happened, and how
long they took. You'll at least know what is happening now. Should
help you figure out how to combine some of those queries.
Also, you could try and bridge the relationships in the query instead
of doing it in python. I think this would give a list of all samurai
in a given province.
Samurai.objects.filter(room__province=current_province)
Sayonara,
Alex
On Feb 24, 2:08 am, Timothy Kinney <timothyjkin...@gmail.com> wrote:
> I have models which describe a game. There are 61 provinces with 9
> rooms in each province, for a total of 549 locations. There are
> several hundred samurai, each assigned to a particular room id.
>
> Province(name, id, exits)
> Room(id, name, foreignkey('Province'))
> Samurai(id, name, foreignkey('Room'))
>
> I want to display a list of samurai (by id) for each province on the
> admin/change_list.html.
>
> I created a method in the Province model:
>
> def samurai(self):
> r = self.room_set.filter(province = self.pk).all()
> output = []
> for i in r:
> output.extend(i.samurai())
> return unicode(output)
>
> I use list_detail.object_list as the generic view and call the
> province.samurai method from my template:
>
> {% for province in object_list %}
> <tr>
> <td>{{ province.name }} [{{ province.id }}] </td>
> <td>{{ province.exits }}</td>
> <td>{{ province.samurai }} </td>
> </tr>
> {% endfor %}
>
> This is very slow, taking almost 4 seconds for 260 samurai.
>
> I know that the reason this is slow is because I am hitting the
> database so inefficiently. I have a for loop where each province is
> iterating 9 times and I am iterating this loop 61times.
>
> I'm new to databases and to django, so I'm trying to understand how I
> can grab all the data in one query and then just use it. I think I
> should do this from the view?
>
> Can you give me a list of steps (in pseudo-code) for optimizing this
> query?
>
> eg:
> 1) Get all objects in province from the view
> 2) create a dictionary
> 3) and so on...
>
> I just don't grok how the template, view, model method, and ORM fit
> together to make an efficient query. :/
>
> -Tim
--
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.
