Skip to content

Only update characters if they have changed name, corp or alliance.

Aaron Kable requested to merge aaronkable/allianceauth:bulk-affiliations into master

Why

We have ~30k characters in our database they take unnecessarily long to update. Most people don't change often, We should only need to update them if they have changed.

In this example this would mean; (4 times a day)

Before

  • 90000 Esi calls
  • 30000 db update calls

After

  • ~120 + (updates_required x 3) ESI calls
  • 60 db select calls + updates_required db update calls
Edited by Aaron Kable

Merge request reports