Add /time/{id}/rank

fiveman1 commented

2025-06-28 16:29:34 +00:00

Old API had a way to get the placement of a time, but the updated one doesn't.

Additionally, could this endpoint also return how many times total are on the map? Would help with displaying a user's placement on a map Nth/X (9th/302).

Old API had a way to get the placement of a time, but the updated one doesn't. Additionally, could this endpoint also return how many times total are on the map? Would help with displaying a user's placement on a map Nth/X (9th/302).

itzaname commented

2025-06-29 04:22:01 +00:00

Owner

I’ll look into adding the total. I’ve got a fairly efficient query that avoids full table scans, so it runs pretty fast. But adding the total would basically double the execution time, so I need to consider if it’s worth it since the game servers are calling this too.

Just to get ahead of the suggestion, I’m not looking to create or maintain a bunch of public API exclusive queries or toggles.

I’ll look into adding the total. I’ve got a fairly efficient query that avoids full table scans, so it runs pretty fast. But adding the total would basically double the execution time, so I need to consider if it’s worth it since the game servers are calling this too. Just to get ahead of the suggestion, I’m not looking to create or maintain a bunch of public API exclusive queries or toggles.

fiveman1 commented

2025-06-29 08:07:19 +00:00

Author

That makes sense. I can use the /times/ API to get the number of times on a given map via the total items so it's not a big deal either way.