New Relationship
Opened this issue · 0 comments
milafrerichs commented
We need to introduce a new Many2Many relationship.
Between Location
and GeographyBoundary
The geo query for getting locations inside a boundary is too slow for our production use case.
Therefore we need to model that geographic relationship ourselves. Which is not that big off a deal.
Locations have many GeographyBoundaries (they can be in different sub level boundaries, e.g. state and district, etc)
And Boundaries have many Locations.
This will make the queries a lot faster.