search

ppy / osu-web

the browser-facing portion of osu!
https://osu.ppy.sh
GNU Affero General Public License v3.0
955 stars 380 forks source link

Add recent score index #11257

Closed peppy closed 3 weeks ago

peppy commented 3 weeks ago

Used primarily for new medals.

@nanaya may want to switch the recent section of profile query to use this index now.

nanaya commented 3 weeks ago

I don't think osu-web recent play on profile should use this index though? It may get pretty slow when also filtering by ruleset id when the user never played anything in that ruleset (or not enough to reach the requested limit).

bdach commented 3 weeks ago

It may get pretty slow when also filtering by ruleset id

For whatever it's worth this index was originally for medal purposes (to look up latest N scores of a user) and it seems to perform pretty well even when filtering by ruleset ID which some medals do. I guess that said the biggest N of scores that medals will be fetching is single digits, so that may not exactly match the use case for web.