Page MenuHomePhabricator

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

Authored by artms on Oct 9 2019, 8:00 AM.

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 SkippedExcuse: libphutil broken
Unit
Unit Tests Skipped
Build Status
Buildable 23550
Build 32363: Run Core Tests
Build 32362: arc lint + arc unit