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.

Sign up for GitHub

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

Indexes missing #65

Open

jgimenez opened this issue Feb 8, 2024 · 1 comment

jgimenez commented Feb 8, 2024

After some time of usage, the dashboard becomes very very slow, up to the point of queries timing out.

I found these two indices help:

ALTER TABLE email_event ADD INDEX timestamp (timestamp);
ALTER TABLE email ADD INDEX project_id_timestamp (project_id,timestamp);

matt-t-d commented Mar 4, 2024

Also consider

ALTER TABLE email ADD INDEX message_id (message_id);

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