3 ms·
Good idea. Times are from my laptop, which is less beefy than the test rig we used: First query: 996s First query with your variation: 593s Second query:
by hglaser 13y ago
Good idea. Times are from my laptop, which is less beefy than the test rig we used:
First query: 996s
First query with your variation: 593s
Second query: 67s
Third query: 21s
- corresation 13y agoDo you have a FK from dashboard_id to dashboards.id by chance? I assume no, as the query is presumably still forced to do an early existence test of the inner join before aggregating.