Fixing an entity-search timeout (BO)
Fixing a timeout on back-office entity search by publisher email, by rewriting the underlying SQL query.
Ruby on Rails
SQL
Performance
MariaDB
Back-office entity search by publisher email (Search::Entity) was exceeding the execution time limit (timeout) and becoming unusable. Rewrote the query to eliminate the timeout and make the search usable again.