From mboxrd@z Thu Jan 1 00:00:00 1970 From: Danny Milosavljevic Subject: Re: [Cuirass] Missing database indexes? Date: Tue, 13 Nov 2018 01:04:58 +0100 Message-ID: <20181113010458.64905407@scratchpost.org> References: <87va54yh0c.fsf@gnu.org> <20181110211128.6dc522da@alma-ubu> <87k1ljr1c7.fsf@gnu.org> <20181113003140.1db9c770@scratchpost.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/NVT3vh.H.yKmoSUsW.dKOQi"; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:57050) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gMMEi-0000Zj-2I for guix-devel@gnu.org; Mon, 12 Nov 2018 19:07:23 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gMMCa-0005hE-Pe for guix-devel@gnu.org; Mon, 12 Nov 2018 19:05:12 -0500 In-Reply-To: <20181113003140.1db9c770@scratchpost.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_/NVT3vh.H.yKmoSUsW.dKOQi Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On Tue, 13 Nov 2018 00:31:40 +0100 Danny Milosavljevic wrote: > Hi Ludo, >=20 > On Sun, 11 Nov 2018 18:06:00 +0100 > ludo@gnu.org (Ludovic Court=C3=A8s) wrote: >=20 > > 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). =20 >=20 > Not exactly what you mean but there's this: >=20 > https://www.sqlite.org/lang_analyze.html >=20 > It does statistical analysis of queries that ran and will optimize for > that case on subsequent connections. >=20 > 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. Also https://www.sqlite.org/optoverview.html#autoindex --Sig_/NVT3vh.H.yKmoSUsW.dKOQi Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEds7GsXJ0tGXALbPZ5xo1VCwwuqUFAlvqFSoACgkQ5xo1VCww uqVEOwf+ONEq86Hjhd5AawvU0xRfoJt8qeqU/mECmLTU/AILhWCrsQ+qBBvwE7LI 8E+vS5YqaLrudZNosPstpzFYZ7hR0ePR9MHWHk5nvziwjk82K1xWkaZyOzzO2DH6 EOzN4uN3/S7+OyTArFZgJ/xBxZHelYSSoxC2f7EuGRvYDRxPETDMp2vy6lfO2RLm 0cWwpllgFi8QB2brMgg4cgtrs4iAJwa7RHhuJTUhUkRnAN16QQcqSvov1o8bDuJ5 06LoGR/Ggbk74AGiapBxc18QL0KCsE4TVDJO02s6B8DFL46dCjyrbq53JgHVXvXg uelDYGfStXKsphECnfBjYjjVjMNwew== =YdqP -----END PGP SIGNATURE----- --Sig_/NVT3vh.H.yKmoSUsW.dKOQi--