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
I also discovered SQLite’s “EXPLAIN QUERY PLAN”, which is pretty cool:
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’.