search

Abstrct / Schemaverse

The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. Compete against other players using raw SQL commands to command your fleet. Or, if your PL/pgSQL-foo is strong, wield it to write AI and have your fleet command itself!
schemaverse.com
PostgreSQL License
356 stars 39 forks source link

Some useful-looking indices #9

Closed cbbrowne closed 12 years ago

cbbrowne commented 12 years ago

... the queries that seem to be reverting to seq scans...

cbbrowne commented 12 years ago

I have a rather larger change here, where I switch to broadly use the POINT type rather than location_x,location_y.

This mostly simplifies code, and allows using stricter distances rather than the more approximate rectangular ranges presently in use.

Abstrct commented 12 years ago

Between this and the changes to move recently we may suddenly have both a game and a community forming!

Currently reviewing all the code and incorporating it into the public server. Thanks Christopher!