From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id EJ04JPGVR19wCQAA0tVLHw (envelope-from ) for ; Thu, 27 Aug 2020 11:16:01 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id YLcEIPGVR1+fDwAAbx9fmQ (envelope-from ) for ; Thu, 27 Aug 2020 11:16:01 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 04ADE940223 for ; Thu, 27 Aug 2020 11:16:00 +0000 (UTC) Received: from localhost ([::1]:55552 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kBFst-0003s7-P5 for larch@yhetil.org; Thu, 27 Aug 2020 07:15:59 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:53904) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kBFsh-0003rm-Pl for guix-devel@gnu.org; Thu, 27 Aug 2020 07:15:48 -0400 Received: from relay5-d.mail.gandi.net ([217.70.183.197]:59105) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kBFse-0000iB-Iq for guix-devel@gnu.org; Thu, 27 Aug 2020 07:15:47 -0400 X-Originating-IP: 90.92.160.122 Received: from bababa (lfbn-idf2-1-1094-122.w90-92.abo.wanadoo.fr [90.92.160.122]) (Authenticated sender: mail@ambrevar.xyz) by relay5-d.mail.gandi.net (Postfix) with ESMTPSA id CF3E31C0005; Thu, 27 Aug 2020 11:15:39 +0000 (UTC) From: Pierre Neidhardt To: zimoun , guix-devel@gnu.org Subject: Re: File search progress: database review and question on triggers In-Reply-To: <86imd4e7cr.fsf@gmail.com> References: <87sgcuh8rb.fsf@ambrevar.xyz> <86imd4e7cr.fsf@gmail.com> Date: Thu, 27 Aug 2020 13:15:39 +0200 Message-ID: <87eenspcf8.fsf@ambrevar.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha256; protocol="application/pgp-signature" Received-SPF: pass client-ip=217.70.183.197; envelope-from=mail@ambrevar.xyz; helo=relay5-d.mail.gandi.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/08/27 05:31:15 X-ACL-Warn: Detected OS = Linux 3.11 and newer X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, FROM_SUSPICIOUS_NTLD=0.499, RCVD_IN_DNSWL_LOW=-0.7, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_PDS_OTHER_BAD_TLD=0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.23 Precedence: list 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+larch=yhetil.org@gnu.org Sender: "Guix-devel" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of guix-devel-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-devel-bounces@gnu.org X-Spam-Score: -3.11 X-TUID: Z9lzzQv94MHb --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Simon! zimoun writes: > If you are going to an local SQL database, my two questions are: > > a) > Which part would update it? =E2=80=9Cguix pull=E2=80=9D? Other? Even u= sing > substitutes, the channels and co could lead to an extra cost and so what > is acceptable and what is not? I suggest fetching database updates when performing the filesearch, just like `guix size` does. The induced cost would be little in my opinion. A compressed database for a whole generation is below 10 MiB. This operation would need to be done only once per Guix generation. If we are a bit smart with timestamping and only send a diff, it could even be much, much smaller. > b) > Could you also include other fields such that =E2=80=9Csynopsis=E2=80=9D = and > =E2=80=9Cdescription=E2=80=9D? Because it could speed up =E2=80=9Cguix s= earch=E2=80=9D without adding > (or modifying) the current cache > (~/config/guix/current/lib/package.cache); discussed at length in > #39258 . I think this is a bit beyond the scope of this patch set. I'd rather focus on files exclusively for now and proceed one step at a time :) Cheers! =2D-=20 Pierre Neidhardt https://ambrevar.xyz/ --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEUPM+LlsMPZAEJKvom9z0l6S7zH8FAl9HldsACgkQm9z0l6S7 zH9LJwf9EbL4Lr15+WRi9A2cH+WthB1zUdrSBEKVspgJ5iQPu4KzE+MVFdUNEc4X dXgf4BFvFv2erFgvLL2ril0nO92DRQ5RtKYaK0XpLMEn6Tmu22Dw7ZFIjhama/k6 OVKw/AshlIb+B8E4sWAJecnUOwVtw00rTt8m7u2EGEJfsUL19PobL74fH18MHASo LtSAp8ykMp4Iocm2qpGaGcre7XEpZzcHNE9FUvNe7Bm0BdO8J9cSD2YmKxvFq2FI 8PI229ofw2s0HjDff77DzpNbgai/fUZ6IOw4LgJvkdC5/xPrbW24zp9JknepYPVL NaWDt5AARdDZ82GmLoNpVXKnWQZE9w== =JwhK -----END PGP SIGNATURE----- --=-=-=--