-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 7.1.X
-
Fix Version/s: 7.0.0 DXP FP80, 7.0.10.11 DXP SP11, 7.0.X, 7.1.10 DXP FP10, 7.1.10.2 SP2, 7.1.3 CE GA4, 7.1.X, Master
-
Component/s: Core Infrastructure > Upgrade Framework
-
Branch Version/s:7.1.x, 7.0.x
-
Backported to Branch:Committed
-
Fix Priority:3
-
Git Pull Request:
Steps to Reproduce: Upgrade with Postgres and millions of records in expandoValue and ExpandoRow tables. The DELETE is rewritten to use NOT EXISTS instead of NOT IN, the query performs MUCH faster in Postgres.
Expected Behavior: Upgrade would complete in a shorter amount of time
Actual Behavior: v7_0_5.UpgradeExpando takes a long time to complete
- is duplicated by
-
LPS-92793 Slow upgrade on UpgradeExpando
- Closed