Travel Mapping

User Discussions => Other Discussion => Topic started by: bejacob on April 10, 2019, 09:26:49 pm

Title: Overall Stats Ranking
Post by: bejacob on April 10, 2019, 09:26:49 pm
Curious if there is any plan to change the TBD on the ranking of the overall stats part of the page. Not something that matters as I would consider it a low priority. Just wondering.
Title: Re: Overall Stats Ranking
Post by: yakra on July 11, 2019, 01:37:26 pm
There's been a GitHub issue (https://github.com/TravelMapping/Web/issues/91) for some time now. It pops back up in discussion every now again, but making a fix never seems to gain much traction.
Quote from: Thing342
FYI: doing this only from the web side results in massive queries that take awhile to process.
Doesn't seem to me this should matter too much, at least in the case of a "Distance Traveled" ranking; we already use a query to get that very same info on http://travelmapping.net/stat.php
Title: Re: Overall Stats Ranking
Post by: yakra on July 13, 2019, 08:04:56 pm
I see what Thing342 means now. The query I'm using takes 1.3s, compared with 0.16s for the next slowest I saw, with everything else < 0.1s.
Double that, for one active & one active+preview query, and ouch.

I'll leave this on my own mirror (http://205.209.84.174/) of the site, maybe even make a commit to a separate branch, but not open a pull request just yet.
Eventually I may look into extra tables that can be created during the site update process to speed up the queries.