Use temp in mem table
On a particularly tough query, running the scheduled job was taking 22s.
With this change, it's down to 9s.
The change is to use a temporary and in-memory table instead of an on-disk permanent table.
Edited by VangelisP
On a particularly tough query, running the scheduled job was taking 22s.
With this change, it's down to 9s.
The change is to use a temporary and in-memory table instead of an on-disk permanent table.