search

ppy / osu-infrastructure

37 stars 5 forks source link

Investigate whether there's a better way to do the recent scores lookup #18

Closed peppy closed 10 months ago

peppy commented 10 months ago

The only reason for index KEY user_ruleset_id_index (user_id,ruleset_id,id DESC) existing is to do recent score display on user profiles.

Historically, we've maintained a separate table for this. We may just want to go back to doing this if it means the main table gets a whole lot smaller.

peppy commented 10 months ago

As per #17, we'll stick to this method for now (as the modified index does need to remain present).