mozilla-releng/balrog

Fix performance issues on public app with new releases tables enabled

Closed this issue · 0 comments

bhearsum commented

When we enabled the new releases tables for the public app we saw roughly a ~3x spike in database load, and a smaller spike in CPU load. Two possible theories (although there may be other explanations:

  1. caching of empty results from the new releases tables are broken
  2. simply querying the new releases tables is causing this increase in load

I would be surprised if it was 2), as the caching should largely negate this. It's still possible though.