Page MenuHomePhabricator

Add index on dateCreated database field because it is used by Feed->Transactions functionality
AbandonedPublic

Authored by epriestley on Oct 9 2019, 8:00 AM.
Tags
None
Referenced Files
F18753547: D20855.id.diff
Sat, Oct 4, 7:24 PM
F18598601: D20855.diff
Sat, Sep 13, 5:23 AM
F18570887: D20855.id49722.diff
Wed, Sep 10, 4:12 AM
F18567460: D20855.id.diff
Tue, Sep 9, 3:48 PM
F18366208: D20855.id49722.diff
Aug 27 2025, 10:02 PM
F18365883: D20855.diff
Aug 27 2025, 9:32 PM
F18364195: D20855.id.diff
Aug 27 2025, 6:35 PM
F18363739: D20855.id49722.diff
Aug 27 2025, 5:15 PM
Subscribers

Details

Summary

It is very expensive to fetch transaction history when you have large transaction history, Feed->Transactions functionality times out in our production environment where differential_transaction has >32million+ records

Test Plan
  1. Added indexes
  2. Checked Feed->Transaction it is no longer timing out

Diff Detail

Repository
rP Phabricator
Branch
transaction-created
Lint
Lint Skipped
Unit
Tests Skipped
Build Status
Buildable 23550
Build 32363: Run Core Tests
Build 32362: arc lint + arc unit