You can, and I'd be interested to know how much of a speedup that
gives. Here's the relevant page on writing raw SQL:
http://docs.djangoproject.com/en/dev/topics/db/sql/
If you know SQL (and it looks like you do) it should be familiar
territory. The interesting bits are deferring fields, and adding
annotations...maybe those could help speed up your query?
Aditya
On Mar 16, 10:37 pm, TheIvIaxx <theivi...@gmail.com> wrote:
> i suppose i could, but that will be a last resort :) What about
> dropping down to raw SQL just to get the IDs:
>
> SELECT term_id FROM image_term WHERE image_id = %i
>
> or is that discouraged? Can it be done with the ORM?
>
> On Mar 16, 8:32 pm, aditya <bluemangrou...@gmail.com> wrote:
>
> > 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.
