added config param for the temporary tables' engine.

using MEMORY per default because all other types are unnecessarily
written into the filesystem and require a lot of IO.