Re: Reduce number of sql calls to database

On Tue, Jun 2, 2015 at 11:48 AM, Cherie Pun <cherie.cy.pun@gmail.com> wrote:
> Hi,
>
> I am new to Django and I am trying to reduce the number of calls to database
> as it's slowing down the app. I am performing iteration over the queryset
> and I used django_debug_toolbar to check the number of queries made, and the
> number is huge. It looks like django is making a query call to the db in
> each iteration. Is there a way to make it only send one query and then store
> the result locally and iterate over it?
>
> Code:
> for level_id in levels_id:
> levels.append(get_object_or_404(Level, id=level_id))
>
> I have been trying out this code, but it seems that the number of sql
> queries is still the same.
> levels_dict = Level.objects.values('id', 'name')
> for level_id in levels_id:
> levels.append(levels_dict.get(id=level_id).get('name'))
>
> I am using the same pattern in a few places to get data from each of the
> object in the queryset, is there a way to improve the performance? I am
> happy to provide any missing information. Cheers!

How about this:

Levels.objects.filter(id__in= levels_id)

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CACwCsY7ydRPHhzm7xFYF3ZODfDgFUsC5yLYGQ-%3DkwZ-xmAqNPw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.