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.