search

Signal-Cartel / EveScoutRescue

Web site and data tools for evescoutrescue.com, maintainer ThriceHappy.
https://evescoutrescue.com/home/
13 stars 10 forks source link

esrcoordadmin.php - Stop the insanity #244

Closed adeadparrot closed 4 years ago

adeadparrot commented 4 years ago

esrcoordadmin.php does two round trips to the database for every single row of the table showing past SAR requests. And the requests are all redundant. This needs to be rewritten.

bikerunner commented 4 years ago

BTW.: It's not just a roundtrip. It opens a total of 3 DB connection and two are fast opened and closed again.

adeadparrot commented 4 years ago

It looks like this could all be done in a single query. If we send the character name of the requester to the query...

Thricehappy commented 4 years ago

Hey, take it easy! I threw this together in an afternoon and it only gets used by the ESR division admin maybe once or twice a week. :-)

But, sure, it can be optimized at this point.

chigaze commented 4 years ago

Seven seconds load time for me now. :)

What I'd really like, though, is a way to edit the Locator and Rescue Pilots but that should probably be another request... may even be on already, I should check.