Details
-
Type: Improvement
-
Status: Open
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: All Time Backlog
-
Component/s: Database/Schema
-
Labels:None
-
Sprint:High Priority
-
Epic Link:
Description
The table structures for location and business taxonomy that are in 3NF are slow when doing parent-child traversal (especially when discovering the root). The encoding used by the business_taxonomy and location_taxonomy tables, which have explicit parent and child id columns is probably the better one to use.