> is it better to put these tables in another database (and in this way maintain another pool of connection to this database) or keep these table in the main database ?

Did you consider using of Global Temporary Tables?

SY, SD.