Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
Tracked by #15
peppy opened this issue Aug 31, 2023 · 1 comment
Closed
Tracked by #15
Assignees

Comments

@peppy
Copy link
Member

peppy commented Aug 31, 2023

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 peppy changed the title Test whether there's a better way to do the recent scores lookup (current reason for index KEY user_ruleset_id_index (user_id,ruleset_id,id DESC) existing) Investigate whether there's a better way to do the recent scores lookup Aug 31, 2023
@peppy peppy self-assigned this Aug 31, 2023
@peppy
Copy link
Member Author

peppy commented Sep 4, 2023

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

@peppy peppy closed this as completed Sep 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant