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
F19507855: D20855.diff
Fri, Jan 9, 11:52 PM
F18846173: D20855.id.diff
Oct 29 2025, 5:22 PM
F18846113: D20855.id.diff
Oct 29 2025, 4:43 PM
F18842083: D20855.diff
Oct 28 2025, 1:12 PM
F18841974: D20855.id49722.diff
Oct 28 2025, 12:36 PM
F18773311: D20855.diff
Oct 9 2025, 8:57 AM
F18773286: D20855.id49722.diff
Oct 9 2025, 8:44 AM
F18753547: D20855.id.diff
Oct 4 2025, 7:24 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