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
Unknown Object (File)
Jun 5 2025, 4:42 PM
Unknown Object (File)
Apr 27 2025, 4:15 PM
Unknown Object (File)
Apr 26 2025, 2:07 PM
Unknown Object (File)
Apr 24 2025, 11:18 PM
Unknown Object (File)
Apr 24 2025, 2:39 AM
Unknown Object (File)
Mar 28 2025, 11:12 PM
Unknown Object (File)
Mar 27 2025, 6:25 PM
Unknown Object (File)
Mar 26 2025, 2:22 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