Scalability issues in party address subdivision
The current design on party address does not scale, since anytime the party model is accessed, it selects all the subdivisions for that country[1]. The performance degradation is such that it makes the system unusable even with reasonably small number of subdivisions.
1.- SELECT "a"."id" AS "id" FROM "country_subdivision" AS "a" WHERE (("a"."country" = 22)) ORDER BY "a"."code" ASC, "a"."id" ASC