From mboxrd@z Thu Jan 1 00:00:00 1970 From: Danny Milosavljevic Subject: Re: [Cuirass] Missing database indexes? Date: Tue, 13 Nov 2018 00:31:40 +0100 Message-ID: <20181113003140.1db9c770@scratchpost.org> References: <87va54yh0c.fsf@gnu.org> <20181110211128.6dc522da@alma-ubu> <87k1ljr1c7.fsf@gnu.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/xSdg8WgRXV.nTFBBuj6Qjz3"; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51794) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gMLgK-0004qH-2n for guix-devel@gnu.org; Mon, 12 Nov 2018 18:31:49 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gMLgG-0003ST-Of for guix-devel@gnu.org; Mon, 12 Nov 2018 18:31:48 -0500 In-Reply-To: <87k1ljr1c7.fsf@gnu.org> List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: Ludovic =?ISO-8859-1?Q?Court=E8s?= Cc: guix-devel@gnu.org, clement@lassieur.org --Sig_/xSdg8WgRXV.nTFBBuj6Qjz3 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Ludo, On Sun, 11 Nov 2018 18:06:00 +0100 ludo@gnu.org (Ludovic Court=C3=A8s) wrote: > I don=E2=80=99t really know what additional index to create (and I=E2=80= =99d rather let > SQLite do it for me, if it were possible). Not exactly what you mean but there's this: https://www.sqlite.org/lang_analyze.html It does statistical analysis of queries that ran and will optimize for that case on subsequent connections. Other than that, I always create indices by hand since it's a one-time effort anyway - so just searching for a solution to automate it takes longer than just adding an index for a column I match on. --Sig_/xSdg8WgRXV.nTFBBuj6Qjz3 Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEds7GsXJ0tGXALbPZ5xo1VCwwuqUFAlvqDVwACgkQ5xo1VCww uqU98Af/c7Hi3ZrzjpqQhn389k/RZPuD1+pwSMClectAzs9rA8tueD4WGzRWrs6C m+scaGR+t+Wv+7dDnVlN1Y71c3Bw3IlqfSGpEqmuy31HQGqZxyLXEM5IBIY2d7Sb hL3R2dh6MSCeqGF1ByeZ1gUkEunY4/2+Sb/4EX3v3Q5w1Ym6QevucRul8ZWjmQ9S VAteRk2CTR+hy6NUoBw27xiqPgJPCNHE7UQGqaJ1mQHUWQfPjy17rseXkXdCBHgS dtgBPS2WenbutZK+YJIM675Pjq3UN3BW/YKgvKRnxE4mjbXbBbJ2AdIeFOz572Ew +HDzIIH8LJAXBQd09mHwRoq41APtSw== =ZceL -----END PGP SIGNATURE----- --Sig_/xSdg8WgRXV.nTFBBuj6Qjz3--