How to optimize django query filter?

Question

Basically I have this url dispatcher that capture a search term with each word separated by + to be search in the query. I have done this this is works but I think this will hit the performance due to repeated search to the database. Is there a better way to do this?

def search(request, **kwargs):
    context = RequestContext(request)
    test = {}
    result = BlogPage.objects.select_related('ImageMedia')

    if 'search_content' in kwargs:
        test['search_content'] = kwargs['search_content']
        if kwargs['search_content'] != '0':
            search_words = kwargs['search_content'].split('+')
            for words in search_words:
                result = result.filter(content__icontains=words)

    context_dict = {'blog_list': result}

    return render_to_response('blog/blog_search.html', context_dict, context)

schneck · Accepted Answer · 2014-10-15 09:38:14Z

2

You could pre-build your filter, like (untested):

from django.db import Q    
search_content = kwargs.get('search_content', '')
myfilter = Q()

for term in search_content.split('+'):
    myfilter |= Q(content__icontains=term)

result = BlogPage.objects.filter(myfilter).select_related('ImageMedia')

edited Oct 15, 2014 at 9:38

answered Oct 15, 2014 at 8:50

schneck

10.9k12 gold badges51 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nameless Over a year ago

It gives me this error. unsupported operand type(s) for |=: 'str' and 'Q'

schneck Over a year ago

This is because you have to preset myfilter first, e.g. myfilter=Q()

Community · Accepted Answer · 2017-05-23 12:11:42Z

0

I think Python list to bitwise operations is simpler when you are using python 2.7

PS: ~~reduce() function has been removed in Python 3, so you can't use it and it is no compatibility~~.reduce() has been move into module functools

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Oct 15, 2014 at 9:09

Neo Ko

1,41516 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to optimize django query filter?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related