Tag: optimization
-
Multi-Tenant: Optimizing Default Data with Nullable Constraints
A little while ago (at work), I ran into a situation where we needed to store around 100 rows of default data, allowing each tenant to add their own custom entries. Initially, it was set up with two tables: While this solution worked in theory, it caused several issues. The default data was duplicated across…