l...@gnu.org (Ludovic Courtès) skribis: > My point is /latestbuilds and /queue already take several seconds on the > database that we have on berlin, which is quite big. So we have a > problem already.
Turns out creating the relevant indexes helps a lot, unsurprisingly I guess: https://git.savannah.gnu.org/cgit/guix/guix-cuirass.git/commit/?id=db27955ad3fae260ee2aa4bace8dd6a4115d338c I also discovered SQLite’s “EXPLAIN QUERY PLAN”, which is pretty cool: https://www.sqlite.org/lang_explain.html With that /latestbuilds still usually takes a bit more than 2 seconds. This could be due to the repeated ‘Outputs’ queries via ‘db-get-outputs’. Ludo’.