From mboxrd@z Thu Jan  1 00:00:00 1970
From: ludo@gnu.org (Ludovic =?utf-8?Q?Court=C3=A8s?=)
Subject: Re: Cuirass news
Date: Thu, 15 Feb 2018 00:17:55 +0100
Message-ID: <877erfqhy4.fsf@gnu.org>
References: <877es6x5xj.fsf@gnu.org> <87lggmjjgo.fsf@gmail.com>
	<87k1w6jjak.fsf@gmail.com> <87h8raxeym.fsf@gnu.org>
	<20180126153005.259a75e8@scratchpost.org> <87zi4z1eb0.fsf@gnu.org>
	<20180127181852.42f0bcbf@scratchpost.org> <87fu6bwqix.fsf@gnu.org>
	<20180208172905.19e9e789@scratchpost.org> <871shvt94p.fsf@gnu.org>
	<20180209000526.5b9ea8e7@scratchpost.org> <87wozm4i12.fsf@gnu.org>
	<20180209122931.5a47e63e@scratchpost.org> <877ermyuj2.fsf@gnu.org>
	<20180209180608.79fb856b@scratchpost.org> <874lmpw0rj.fsf@gnu.org>
	<20180213101236.5c74e577@scratchpost.org> <87zi4bsn37.fsf@gnu.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:51319)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <ludo@gnu.org>) id 1em6JM-0004aw-Dn
	for guix-devel@gnu.org; Wed, 14 Feb 2018 18:18:01 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <ludo@gnu.org>) id 1em6JL-0002kA-Dg
	for guix-devel@gnu.org; Wed, 14 Feb 2018 18:18:00 -0500
Received: from hera.aquilenet.fr ([2a0c:e300::1]:59510)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <ludo@gnu.org>) id 1em6JL-0002iW-5v
	for guix-devel@gnu.org; Wed, 14 Feb 2018 18:17:59 -0500
In-Reply-To: <87zi4bsn37.fsf@gnu.org> ("Ludovic
	\=\?utf-8\?Q\?Court\=C3\=A8s\=22'\?\=
	\=\?utf-8\?Q\?s\?\= message of "Wed, 14 Feb 2018 14:43:56 +0100")
List-Id: "Development of GNU Guix and the GNU System distribution."
	<guix-devel.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/guix-devel>,
	<mailto:guix-devel-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/guix-devel/>
List-Post: <mailto:guix-devel@gnu.org>
List-Help: <mailto:guix-devel-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/guix-devel>,
	<mailto:guix-devel-request@gnu.org?subject=subscribe>
Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org
Sender: "Guix-devel" <guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org>
To: Danny Milosavljevic <dannym@scratchpost.org>
Cc: guix-devel <guix-devel@gnu.org>

ludo@gnu.org (Ludovic Court=C3=A8s) 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=3Ddb27=
955ad3fae260ee2aa4bace8dd6a4115d338c

I also discovered SQLite=E2=80=99s =E2=80=9CEXPLAIN QUERY PLAN=E2=80=9D, wh=
ich 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 =E2=80=98Outputs=E2=80=99 queries via =E2=
=80=98db-get-outputs=E2=80=99.

Ludo=E2=80=99.