cubicweb #481715 [multisource] optimize usage of temporary tables [deprecated]

getting data from multiple sources leads to the creation of a temporary table. Those tables are costly to create and should be avoided if possible or at least created only once and not inside every transaction.

Here is a thread about cost of temporary tables on postgresql :

Which is summarized by this sentence :

As I learned today, creating a temporary table in PostgreSQL can easily create four files and do dozens of updates to system tables; that's all before you start actually inserting any data into the temporary table.

We could use ON COMMIT DELETE ROWS if the table are created only once per session.

appeared in<not specified>
done in<not specified>
load left0.000
closed by<not specified>