Structural table volumes
Consider the following best practices when handling table pick list columns.
Parent-child relationships with structural tables
Similar to table pick list columns, when Incentives data and custom tables include pick-listed columns, they create a parent-child relationship, with the structural table as the parent.
Performance impact due to increased table volume
Insertion and updating of records
Insertion and updating of records may take longer as structural table volumes increase. This is due to data validity checks against a larger number of records.
Historically, volumes under 10,000 records have not caused import issues. However, there was a case where a structural table with 1 million records caused long-running imports and queries.
Recommendations for managing structural table volumes
It is essential to understand the volumes of every structural table in use to understand the impact their size can have on performance.
Focus on ways to break up data if the structural table volumes are significantly larger than the 10,000 record threshold to avoid performance degradation.