From debbugs-submit-bounces@debbugs.gnu.org Tue Feb 11 14:07:49 2020 Received: (at 39258) by debbugs.gnu.org; 11 Feb 2020 19:07:49 +0000 Received: from localhost ([127.0.0.1]:57553 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j1asu-0001tB-Vq for submit@debbugs.gnu.org; Tue, 11 Feb 2020 14:07:49 -0500 Received: from mugam.systemreboot.net ([139.59.75.54]:39568) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1j1asr-0001t0-G8 for 39258@debbugs.gnu.org; Tue, 11 Feb 2020 14:07:47 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=systemreboot.net; s=default; h=Content-Type:MIME-Version:Message-ID:Date: References:In-Reply-To:Subject:Cc:To:From:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date: Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id: List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=dWwvXq2h0nPLqZkCN248aPTXqYXwC6j1nkR+IzH3O5w=; b=LPRG7y9LDnNhbAefgUW5f6ivK 1hPKfV7y7CG15l5GnJVMFIxyQ2IswOyCaCPWhXob9btazOnXUnI+PtyS91MiS1ZjkuXFBcMlWqlU5 mfUbHU2Ioi45k+w36M6zQ3tCq+ag6CsW6I0ehaSDP+4wVUT8ZqbLwzmRZ8s85i+DZ9Juw=; Received: from [192.168.2.1] (helo=steel) by systemreboot.net with esmtpsa (TLS1.3) tls TLS_AES_256_GCM_SHA384 (Exim 4.93) (envelope-from ) id 1j1asb-001VB3-VN; Wed, 12 Feb 2020 00:37:30 +0530 From: Arun Isaac To: Ludovic =?utf-8?Q?Court=C3=A8s?= , zimoun Subject: Re: [bug#39258] Faster guix search using an sqlite cache 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" X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 39258 Cc: 39258@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) --=-=-= 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----- --=-=-=--