search

Nikeev / sesdashboard

Analytics and activity tracking dashboard for AWS Simple Email Service
https://sesdashboard.com/
MIT License
86 stars 27 forks source link

MySQL index missing #51

Closed jgimenez closed 1 year ago

jgimenez commented 1 year ago

After a few thousand emails are stored in the database the application becomes sluggish, up to the point it just times out.

Creating this index resolves the issue:

CREATE INDEX idx_project_id_message_id ON email(project_id, message_id) USING HASH;
Nikeev commented 1 year ago

Hello!

Thanks for you suggestion! I'll add it with closest updates

Nikeev commented 1 year ago

Hello!

Added a new migration with index on email table.

Run ./bin/console doctrine:migrations:migrate -n to apply migration