2 ms·
Interesting. For http://greenfelt.net http://greenfelt.net we have a single PostgreSQL DB and store all our games in one big table. For the score based games (l
by __david__ 16y ago
Interesting. For http://greenfelt.net http://greenfelt.net we have a single PostgreSQL DB and store all our games in one big table. For the score based games (like tetris) we do everything with Postgres's great expression indices to segregate things into daily, weekly, and monthly high scores ("DATE_TRUNC('YEAR',date at time zone 'UTC')"). We use Postgres's windowing functions to get the ranking numbers.
We don't have very high traffic though--we manage roughly 3000 games/hour at our peak times with our one DB server.