Description:
When the dataset size grows large, deleting orphan entities frequently times out
Context:
Dataset size: Over 45,000 entities
Investigation & Mitigation Attempted:
We've verified the following in our environment: Replaced the original OUTER JOIN + scalar_subquery logic with EXISTS subquery
Description:
When the dataset size grows large, deleting orphan entities frequently times out
Context:
Dataset size: Over 45,000 entities
Investigation & Mitigation Attempted:
We've verified the following in our environment: Replaced the original OUTER JOIN + scalar_subquery logic with EXISTS subquery