Just pushed a major performance pass on the site - especially the Recent Killmails feed.
Before: ~15–20 seconds per page load (sometimes worse) Now: feels ~0.25–1.0 seconds (tested on desktop + phone on cell data)
What changed (high level):
The killmails page was doing “heavy” database work each request, bad idea with a table this big - we’re at ~39,000,000 killmails indexed, and adding more everyday from historical records and new incoming killmails.
The feed is now fetched in a way that stays index-friendly and avoids expensive operations that scale with table size.
Any non-critical enrichment work (like missing value data) is handled outside the page-load path so the page stays snappy.
If you notice anything weird (pagination edge cases, missing cards, odd ordering), let us know in the community support channel in discord or the support forums of this website!
More optimization work is coming, but this one was a big win for us. 🚀
Before: ~15–20 seconds per page load (sometimes worse) Now: feels ~0.25–1.0 seconds (tested on desktop + phone on cell data)
What changed (high level):
The killmails page was doing “heavy” database work each request, bad idea with a table this big - we’re at ~39,000,000 killmails indexed, and adding more everyday from historical records and new incoming killmails.
The feed is now fetched in a way that stays index-friendly and avoids expensive operations that scale with table size.
Any non-critical enrichment work (like missing value data) is handled outside the page-load path so the page stays snappy.
If you notice anything weird (pagination edge cases, missing cards, odd ordering), let us know in the community support channel in discord or the support forums of this website!
More optimization work is coming, but this one was a big win for us. 🚀