[kileywm]

Product.objects.filter(color="red")

This is the efficient one, filtering results upstream, via SQL, before they are returned to the client.