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

Add (unique) index to forum_member_id #501

Open
wilson29thid opened this issue Feb 21, 2021 · 0 comments
Open

Add (unique) index to forum_member_id #501

wilson29thid opened this issue Feb 21, 2021 · 0 comments

Comments

@wilson29thid
Copy link
Contributor

I can't believe it, but we haven't had an index on members.forum_member_id this whole time. Literally every API request in a logged in session does a lookup on that column 😬

While we're at it, we should make it a unique index. But there are two isues with that: there are a bunch of records with the value set to 0, as well as 4 duplicates somehow.

Screenshot 2021-02-21 at 11 47 00

Might be easier to just wait until after the discourse transition, as those values will be reset.

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