GNU bug report logs

#39258 Faster guix search using an sqlite cache

PackageSource(s)Maintainer(s)
guix-patches PTS Buildd Popcon
Full log

Message #346 received at 39258@debbugs.gnu.org (full text, mbox, reply):

Received: (at 39258) by debbugs.gnu.org; 13 Jun 2020 13:37:09 +0000
From debbugs-submit-bounces@debbugs.gnu.org Sat Jun 13 09:37:09 2020
Received: from localhost ([127.0.0.1]:41089 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces@debbugs.gnu.org>)
	id 1jk6LN-0001AP-Cd
	for submit@debbugs.gnu.org; Sat, 13 Jun 2020 09:37:09 -0400
Received: from mail-wr1-f47.google.com ([209.85.221.47]:37874)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <zimon.toutoune@gmail.com>) id 1jk6LK-0001A2-R5
 for 39258@debbugs.gnu.org; Sat, 13 Jun 2020 09:37:07 -0400
Received: by mail-wr1-f47.google.com with SMTP id x13so12626397wrv.4
 for <39258@debbugs.gnu.org>; Sat, 13 Jun 2020 06:37:06 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025;
 h=from:to:cc:subject:in-reply-to:references:date:message-id
 :mime-version; bh=7ttlD2/BQV3EpWrj8Few+mcd6bPps0SOY3FUt9eU1Eo=;
 b=Hk9cOQRbGefb8YrDE/hIacU5dT6B8kwuM1yDhr4+ZQc64B9O92GBqY9atMKy+UwSm3
 z4G+E+AXfUqXAehW1oZVgpzwXZZ+Yac07gz3rmM1KZJBD0vqS+gYarOH1w/wg1yEZiwh
 MEf17Ezy+648yDSzJDvJhyL9s8KOfZcnKZ2GHXQ1d/v4nCzX38shEP6a8wYd4lqw4qSc
 usIBtx4NgHW6nfku/2nJmCvpI+arVX0L5K1/TiAM38bya80HTfocDu3ogd1EL7APp6oj
 b4/OrZX1QSOM54jvIqXQOOMAZDAfLCWSE7JQOf2whOr0Sm4rQh04fM8KL/uol7f59r6E
 /A5A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20161025;
 h=x-gm-message-state:from:to:cc:subject:in-reply-to:references:date
 :message-id:mime-version;
 bh=7ttlD2/BQV3EpWrj8Few+mcd6bPps0SOY3FUt9eU1Eo=;
 b=ISg+qUKhQpCqtQTZOl96lpF/dmYSyZpxrFYnMCNQg46BMdKI7KWdowE4WH3J57qlEF
 ubUF05vB1G9jepnW8dVd4zjFzyheWlHZQ+PEbjeUXqtT7aoILb+IR55LHI5KjQD5PHON
 fKP+7t28IyV64l51Fvs7zg2ZlGvGjPO9YYgKr7DCUAUrAs4T7/2prls3BPBR+QFfNPLa
 5p1wnidDq7GjY7EvYHxs12O3K0G799YU7GbkluYckIzhxrZzMrfSbTlwI6oWD4VFwasI
 HCcDhaSnklF/E3E5U37bHzw6bUehoqWezsZBJKDqwRZHs7KlplGubbtaVdaYQDfDSVm5
 1zKA==
X-Gm-Message-State: AOAM532zI7oEacrIfD96NhKBwdfxMQZX+JBT0EJ44JwdGp97pUUvC9yL
 2cOXxf14tKg/ox8aR7Qk1jrchCCqHGs=
X-Google-Smtp-Source: ABdhPJyeJHrqzvEbN13ejwjU7a7sKCNu+LvKn44uypRZ07WQDXKBG641zixI8PT0MGKm+yTn1Ns1Ng==
X-Received: by 2002:adf:e883:: with SMTP id d3mr19646300wrm.274.1592055420700; 
 Sat, 13 Jun 2020 06:37:00 -0700 (PDT)
Received: from lili (57.246.195.77.rev.sfr.net. [77.195.246.57])
 by smtp.gmail.com with ESMTPSA id h27sm17416598wrb.18.2020.06.13.06.36.59
 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
 Sat, 13 Jun 2020 06:37:00 -0700 (PDT)
From: zimoun <zimon.toutoune@gmail.com>
To: Arun Isaac <arunisaac@systemreboot.net>, Ludovic Courtès <ludo@gnu.org>
Subject: Re: [bug#39258] [PATCH 2/4] ui: Use string matching with literal
 search strings.
In-Reply-To: <cu7bllnnnty.fsf@systemreboot.net>
References: <20200601000030.7443-1-arunisaac@systemreboot.net>
 <20200601000030.7443-3-arunisaac@systemreboot.net> <87y2owmyf3.fsf@gnu.org>
 <cu7bllnnnty.fsf@systemreboot.net>
Date: Sat, 13 Jun 2020 15:36:57 +0200
Message-ID: <865zbvjddy.fsf@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain
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: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request@debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit@debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request@debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request@debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces@debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces@debbugs.gnu.org>
X-Spam-Score: -1.0 (-)
Dear Arun,

On Sat, 13 Jun 2020 at 18:07, Arun Isaac <arunisaac@systemreboot.net> wrote:

>> How does this affect performance?
>
> See my results from earlier.
>
> --8<---------------cut here---------------start------------->8---
> time ./pre-inst-env guix search game
>
> real	0m2.261s
> user	0m2.351s
> sys	0m0.104s
> --8<---------------cut here---------------end--------------->8---
>
> --8<---------------cut here---------------start------------->8---
> time guix search game
>
> real	0m2.661s
> user	0m2.843s
> sys	0m0.080s
> --8<---------------cut here---------------end--------------->8---

I confirm that it changes nothing.  See [1].

1: http://issues.guix.gnu.org/39258#112


On the other hand, on my machine I do not see any timing improvement with
this patch set.  Could you check that you are comparing apple to apple?


All the best,
simon





Send a report that this bug log contains spam.


debbugs.gnu.org maintainers <help-debbugs@gnu.org>. Last modified: Thu Jul 10 12:57:05 2025; Machine Name: wallace-server

GNU bug tracking system

Debbugs is free software and licensed under the terms of the GNU Public License version 2. The current version can be obtained from https://bugs.debian.org/debbugs-source/.

Copyright © 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson, 2005-2017 Don Armstrong, and many other contributors.