On Tue, Jun 2, 2015 at 11:48 AM, Cherie Pun <[email protected]> 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 [email protected]. To post to this group, send email to [email protected]. 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.
