change from temporary to non-temporary tables in order to support multiple connections