Only update characters if they have changed name, corp or alliance.
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