Page MenuHomePhabricator

BaGLAMa2 has very long running queries
Closed, ResolvedPublic


Hi, the tool BaGLAMa2 is executing on tools labs very long running queries, up to ~65000 seconds, please optimize them ASAP because they're affecting the database performances.

All the long queries are of type:

SELECT DISTINCT AS id,title,namespace_id,grok_code,server FROM views,group2view,sites WHERE group_status_id=<const> AND AND AND done=0 AND namespace_id=0 ORDER BY rand() LIMIT 2000;