From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from eggs.gnu.org ([2001:470:142:3::10]:59277) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1j1atA-0008Vi-Qn for guix-patches@gnu.org; Tue, 11 Feb 2020 14:08:05 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1j1at9-0001vU-0U for guix-patches@gnu.org; Tue, 11 Feb 2020 14:08:04 -0500 Received: from debbugs.gnu.org ([209.51.188.43]:51580) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1j1at8-0001uh-Lb for guix-patches@gnu.org; Tue, 11 Feb 2020 14:08:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1j1at8-0001tb-EV for guix-patches@gnu.org; Tue, 11 Feb 2020 14:08:02 -0500 Subject: [bug#39258] Faster guix search using an sqlite cache Resent-Message-ID: From: Arun Isaac In-Reply-To: <87sgjhx92g.fsf@gnu.org> References: <8736bhytn9.fsf@gnu.org> <87sgjhx92g.fsf@gnu.org> Date: Wed, 12 Feb 2020 00:37:23 +0530 Message-ID: MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha256; protocol="application/pgp-signature" List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-patches-bounces+kyle=kyleam.com@gnu.org Sender: "Guix-patches" To: Ludovic =?UTF-8?Q?Court=C3=A8s?= , zimoun Cc: 39258@debbugs.gnu.org --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable >>> I would rather keep the current package cache as-is instead of inserting >>> sqlite in here. I don=E2=80=99t expect it to bring much compared >>> performance-wise to the current simple cache (especially if we look at >>> load time), and it does increase complexity quite a bit. >> >> Complexity is about taste. ;-) > > It=E2=80=99s measurable to some extent (lines of code, cyclomatic complex= ity, > etc.) I agree with Ludo here. I think it does increase the complexity, and probably unnecessarily so. > Arun started the discussion on guix-devel with the idea of an inverted > index, and I thought this would become a second index (possibly > implemented using SQLite). Perhaps I misunderstood the discussion all > along though, let me know! :-) No, you didn't misunderstand. That's where it began. But, while implementing it, I thought I might as well replace the existing cache. Also, I've started working on guile-xapian bindings. With that, it seems simpler to keep the current package cache and add a xapian index only to speed up package search. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEf3MDQ/Lwnzx3v3nTLiXui2GAK7MFAl5C+2sACgkQLiXui2GA K7O3DQgAnz3GCW1FVXQowVB/RqkTb4meDytN8r/LXnA06VVUHhjPuMMSV6d2xPj8 B9p0lagCeCYN8ivFvBq0X5qFwT4gBtmdXWkn2VmU4nBvUAw+uFd9d5S8bFjNeXe4 IGnmWOBuokF6ttYRkGH9Z4wStz49a/9CJcVW4jpCKyjEyodM/PJ9bVOiOTFgqpFA TTQhMSQM1GuJO8OKhctsyZ8xpNejTW/LFPe2CgoIEQavdlMnzgL7Nl3d5NOa2rS8 VyIamqbofxI9Uj9QBXjn8HxIV5FaA2On/XmWXF/uCr44Fw1xGLyy/AFlReE9KgJE jP/TUwhXMr/s9/e8k0bEDQMESnEfFw== =L3bY -----END PGP SIGNATURE----- --=-=-=--