So I have 2 models, ModelOne
and ModelTwo
, both of which have a my_field
attribute. I want to count how many distinct ModelTwo
objects there are, such that my_field
uniquely exists in ModelTwo
and not in ModelOne.
With a small enough dataset, I could write a simple inefficient function and get the data I need, but both ModelOne
and ModelTwo
have several million objects. So I figure that just getting the intersection count of how many my_field
values are shared between the two tables would be enough, since subtracting that count from ModelTwo
total count would give me the number I'm looking for.
What's a good, efficient, way to get this intersection count?
Aucun commentaire:
Enregistrer un commentaire