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

Fetching servers is SUPER slow #94

Open
matthew-robertson opened this issue May 26, 2020 · 1 comment
Open

Fetching servers is SUPER slow #94

matthew-robertson opened this issue May 26, 2020 · 1 comment

Comments

@matthew-robertson
Copy link
Owner

It's currently not a problem, since only one server is ever fetched at a time, and no server has many banned words.

However, I have an endpoint available to grab all servers, which, at this point in time (at 8.3k rows) takes almost 13 seconds to return, which is untenable. I think this is because I'm fetching the servers using sql, then programatically requesting each server's bans. There's probably a tricky (or not so tricky) way to do this in a join all at once, to save a ton of time.

@kevinjosethomas
Copy link

What database software does the bot use?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants