django-vote
django-vote copied to clipboard
shellfly
Is there anyway to do a select_related() to prevent additional database hit
I want to get the voters of an instance. That way I will check in the frontend if has already voted and displayed a UI according to that status. But getting the review.votes.user_ids() results in additional database hit. How to get this value without some additional database hits?
I tweaked my app, for now, to use prefetch_related('votes'). But this will still result in a 1-time additional database hit. I want to avoid that altogether if possible.
You can use the annotate method, pass in a query set and the current user id, it will return a new query set with is_voted_up and is_voted_down property set on the records you are fetching.
It's still an additional database hit but it's only one hit per query set, not per instance.
