Is there any way you could reduce the # of images to return? Another
thing you could do is cache this info so you don't have to do it
multiple times.
Aditya
On Mar 16, 10:24 pm, TheIvIaxx <theivi...@gmail.com> wrote:
> Hello all, i have a question about a certain query i have. Here is my
> model setup:
>
> class Term():
> term = CharField()
>
> class Image():
> image = FileField()
> terms = ForeignKey(Term)
>
> These have been abbreviated for simiplicity, ut you get the gist of
> it. Anyhow i have to query for a few hundred Image objects, then get
> a list of Term objects for each of these. Really i just need the IDs
> of the Terms. Currently i have my query like this:
>
> images = Image.objects.all()
>
> responseImages = []
> for i in images:
> terms = [term.id for term in n.terms.all()]
> responseObjects.append({'image': n, 'terms': terms})
>
> Am i losing some efficiency here? Seems like a fairly common
> operation, but I think each of the list comprehensions is a db hit.
> on ~300 objects, thats a lot of queries.
>
> Any advice on this one?
>
> Thanks
--
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.
