Actions
Bug #10147
closedbp-reply-by-email status check runs a slow MySQL query
Status:
Resolved
Priority name:
Normal
Assignee:
Category name:
Reply By Email
Target version:
Start date:
2018-08-14
Due date:
% Done:
0%
Estimated time:
Deployment actions:
Description
Query Monitor is reporting a slow query on each pageload, which originates with RBE. See screenshot.
This appears to be at least somewhat due to the Cavalcade jobs table's schema. I wonder if we could add an index that would speed it up.
On RBE's end, do you think it's wise or possible to throttle the status checks? Once per pageload seems really frequent.
Files
Actions