Our query for getting the list of jobs for the resultsets is complex with many joins. We should optimize this with the proper indexes and such. Perhaps consulting with a DBA to help get this right. This query is our main bread-and-butter query that we make all the time for initial page load and job updates.
Priority: -- → P4
Summary: optimize our jobs query → Optimize the query used to fetch jobs data
The query will have changed considerably, now we're using the ORM. Let's rely on New Relic for determining which new bugs we need to open for query optimisation.
Status: NEW → RESOLVED
Last Resolved: a year ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.