Skip to content

Add a missing index on the "message" table

Mikael Davranche requested to merge 26-add-missing-index-on-message-table into master

Closes #26 (closed)

Applied to erine.email SaaS:

MariaDB [spameater]> select sql_no_cache id from message where messageId='<4d3a21f6f87af281f10c24b3e2ba5935@xxx>';
+----+
| id |
+----+
|  1 |
+----+
1 row in set (0.791 sec)

MariaDB [spameater]> create index `message_idx1` on `message` (`messageId`);
Query OK, 0 rows affected (5.120 sec)               
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [spameater]> select sql_no_cache id from message where messageId='<4d3a21f6f87af281f10c24b3e2ba5935@xxx>';
+----+
| id |
+----+
|  1 |
+----+
1 row in set (0.000 sec)

Merge request reports