[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Cuirass news

From: Ludovic Courtès
Subject: Re: Cuirass news
Date: Thu, 15 Feb 2018 00:17:55 +0100
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.3 (gnu/linux)

address@hidden (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’.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]