Django filter vs exclude

Question

Is there a difference between filter and exclude in django? If I have

self.get_query_set().filter(modelField=x)

and I want to add another criteria, is there a meaningful difference between to following two lines of code?

self.get_query_set().filter(user__isnull=False, modelField=x)

self.get_query_set().filter(modelField=x).exclude(user__isnull=True)

is one considered better practice or are they the same in both function and performance?

question from:https://stackoverflow.com/questions/2422380/django-filter-vs-exclude

Answer 1

Both are lazily evaluated, so I would expect them to perform equivalently. The SQL is likely different, but with no real distinction.