]> git.ipfire.org Git - pbs.git/commit
backend: Move temporary tables into CTEs
authorMichael Tremer <michael.tremer@ipfire.org>
Fri, 21 Jul 2023 09:54:07 +0000 (09:54 +0000)
committerMichael Tremer <michael.tremer@ipfire.org>
Fri, 21 Jul 2023 09:54:07 +0000 (09:54 +0000)
commitd4ecf08d9c38a71e1061a91098c35c12b96da7a5
tree0d5bd189c213f56e205178fef3ed9a732b184136
parent7b7fbf0990c1caa8e96bf1a02ed42b533edbcbbc
backend: Move temporary tables into CTEs

It was a nice idea, but if we want to pool connections, we will only
create the temporary tables on one connection with the others losing
out.

An alternative could have been to create all tables on all connections
first, but I suppose that is going to create a lot of unnecessary
overhead for short-lived connections.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
src/buildservice/builds.py
src/buildservice/events.py
src/buildservice/jobs.py
src/buildservice/packages.py
src/buildservice/users.py