search

PDHdata / SmallFormats

Deck-stats server for less-common Magic: the Gathering formats
MIT License
6 stars 0 forks source link

Top cards query is a little slow #48

Closed vtbassmatt closed 1 year ago

vtbassmatt commented 1 year ago

All the top-cards queries take a noticeable amount of time to run.

vtbassmatt commented 1 year ago

f441749f10530a079d6d2c549e37a240795a9a93 has some attempts at speedup.

vtbassmatt commented 1 year ago

Those indexes (which shaved ~10% in SQLite) may have made it worse in Postgres 😢

vtbassmatt commented 1 year ago

Added caching for the slowest pages. Could consider cache-warmup in the daily maintenance script, but for now, it's good.