From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id qJ4mM5AZe1/eRgAA0tVLHw (envelope-from ) for ; Mon, 05 Oct 2020 13:03:12 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id KIjkLpAZe1+dYgAAB5/wlQ (envelope-from ) for ; Mon, 05 Oct 2020 13:03:12 +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 6FF239401BD for ; Mon, 5 Oct 2020 13:03:12 +0000 (UTC) Received: from localhost ([::1]:43578 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kPQ91-0003Dm-Dj for larch@yhetil.org; Mon, 05 Oct 2020 09:03:11 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:41450) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kPQ8s-00039d-LK for bug-guix@gnu.org; Mon, 05 Oct 2020 09:03:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:36765) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kPQ8s-0001xV-B0 for bug-guix@gnu.org; Mon, 05 Oct 2020 09:03:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1kPQ8s-0003MY-8M for bug-guix@gnu.org; Mon, 05 Oct 2020 09:03:02 -0400 Subject: bug#43791: cuirass: Search queries are too slow. Resent-From: Mathieu Othacehe Original-Sender: "Debbugs-submit" Resent-To: bug-guix@gnu.org Resent-Date: Mon, 05 Oct 2020 13:03:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: cc-closed 43791 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: 43791-done@debbugs.gnu.org Mail-Followup-To: 43791@debbugs.gnu.org, othacehe@gnu.org, othacehe@gnu.org Received: via spool by 43791-done@debbugs.gnu.org id=D43791.160190296912898 (code D ref 43791); Mon, 05 Oct 2020 13:03:02 +0000 Received: (at 43791-done) by debbugs.gnu.org; 5 Oct 2020 13:02:49 +0000 Received: from localhost ([127.0.0.1]:48310 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kPQ8e-0003Ly-Tz for submit@debbugs.gnu.org; Mon, 05 Oct 2020 09:02:49 -0400 Received: from eggs.gnu.org ([209.51.188.92]:34522) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kPQ8c-0003Lf-Ik for 43791-done@debbugs.gnu.org; Mon, 05 Oct 2020 09:02:47 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:58162) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kPQ8W-0001w6-S6 for 43791-done@debbugs.gnu.org; Mon, 05 Oct 2020 09:02:41 -0400 Received: from [2a01:e0a:19b:d9a0:4d1:e5e4:e52d:9d3f] (port=51548 helo=cervin) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1kPQ8L-0004Vt-7K for 43791-done@debbugs.gnu.org; Mon, 05 Oct 2020 09:02:32 -0400 From: Mathieu Othacehe References: <87mu12p7ec.fsf@gnu.org> Date: Mon, 05 Oct 2020 15:02:27 +0200 In-Reply-To: <87mu12p7ec.fsf@gnu.org> (Mathieu Othacehe's message of "Sun, 04 Oct 2020 13:17:31 +0200") Message-ID: <87r1qc7rmk.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -3.3 (---) X-BeenThere: bug-guix@gnu.org List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-guix-bounces+larch=yhetil.org@gnu.org Sender: "bug-Guix" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=pass (policy=none) header.from=gnu.org; spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Spam-Score: -1.51 X-TUID: ZTB5FJTbybJc > However, searching for 'hurd-barebones.qcow2%' also skips the index. That's because the index was not created in case insensitive mode. I dropped support for searching with "^" and "$" characters as this is not compatible with using an index and hence way too slow. The new search behaviour is to remove any "%" that could be added by the user, and add one at the end of the query. It should be enough for the modest search needs in Cuirass and reasonable in term of performance (< 10 ms). Anyway, fixed with: 930c2f315c6a9768d31a80d35d2a2550b588deaa. Thanks, Mathieu