Show all indexes you have, and the EXPLAIN QUERY PLAN. But it is probably just a missing index on: "name, checkDate" or "checkDate,name" on the table Traffic.
Show all indexes you have, and the EXPLAIN QUERY PLAN. But it is probably just a missing index on: "name, checkDate" or "checkDate,name" on the table Traffic.