Christopher Browne

Actually, I suggest taking a look at issue #16 https://github.com/Abstrct/Schemaverse/issues/16 first. I think the partial index on ships (player_id) where (not destroyed) would provide a significant improvement here. Note that...

Trivial thing; just loads the schema. (Possibly badly.) https://github.com/cbbrowne/Schemaverse/commit/fc9bfac15bf1a6b58996715819ed3de96adcbe46

Yeah, running the perl script is an apropos addition. I'm not sure it's necessary to force completely deterministic results (e.g. - make the random bits repeatable). The usual approach to...

Ah, interesting. I'll bet I ought to optimize some of my fleet queries to use CIRCLE() rather than distance calcs, although benchmarking has been showing the latter to _seem_ quick...

Upon further reflection, I think that there's something rather ill-fated about having ships_near_ships. It's a table that is _enormously_ expensive in a war zone where there are two fleets of...

The above patch should get looked at closely; I'm not at all sure it is correct. ON THE OTHER HAND... I found missing piece in round_control()... I noticed that the...

Public DB's down at the moment, so I can't offer up samples/query plans, but it looks likely to me that the use of CTEs for the event view may have...

Here's a patch that creates 3 views: 1. My self-inflicted events 2. Other-inflicted events 3. Public events https://github.com/cbbrowne/Schemaverse/commit/c027eebe99992be5fc7bc06ede1c90dce9cc1301 Grab any indexes that you like...

I was thinking a bit more last night about the BURN notion, and I think I have an improvement in this regard to consider... Was thinking about how to head...

I'm still musing about this, by the way. I'm unhappy at this point with the MOVE() interface. It doesn't appear to be working, in the sample game. Take a look...