From nobody Mon Feb 9 09:34:20 2026 Delivered-To: importer@patchew.org Received-SPF: pass (zohomail.com: domain of lists.xenproject.org designates 192.237.175.120 as permitted sender) client-ip=192.237.175.120; envelope-from=xen-devel-bounces@lists.xenproject.org; helo=lists.xenproject.org; Authentication-Results: mx.zohomail.com; spf=pass (zohomail.com: domain of lists.xenproject.org designates 192.237.175.120 as permitted sender) smtp.mailfrom=xen-devel-bounces@lists.xenproject.org; dmarc=fail(p=none dis=none) header.from=eu.citrix.com ARC-Seal: i=1; a=rsa-sha256; t=1596196863; cv=none; d=zohomail.com; s=zohoarc; b=T8Gre/NwEgSDlKbUT/YyBv/8Ar2MVOPpBA1ISGMxjcwUnlEF9UJrOa/WGOg2Y6JQQvXEx4n4wyqAlJrz8Odmz/GSLunPJBYwFjVrdnQlJfFLhZggtF/4IWwBmhdGurrb6ujhNwWEJmrtMcQCfS3SJtsljK0Ddex4txZ0DE6q30w= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1596196863; h=Content-Transfer-Encoding:Cc:Date:From:In-Reply-To:List-Subscribe:List-Post:List-Id:List-Help:List-Unsubscribe:MIME-Version:Message-ID:References:Sender:Subject:To; bh=1dQ//Sw7HHt4gHGTSJ1nQQt0MUpFB7vysgRSCik9i/g=; b=TzUfM5Z1LrAqtl90ieOm1EtFhwhG3YS7M3HJ9d8PwfttnlUpooxIJfXrkUZmbCjqKy6wA835lnuIJOwdjZ3n1zsbwPLMsKs5dowb5HYgj8juM+pp6OgkpMIbLCemOP6gyxv6jli662JJhn6ovZTqvMZBALq/HYbk/a3itHO/XEU= ARC-Authentication-Results: i=1; mx.zohomail.com; spf=pass (zohomail.com: domain of lists.xenproject.org designates 192.237.175.120 as permitted sender) smtp.mailfrom=xen-devel-bounces@lists.xenproject.org; dmarc=fail header.from= (p=none dis=none) header.from= Return-Path: Received: from lists.xenproject.org (lists.xenproject.org [192.237.175.120]) by mx.zohomail.com with SMTPS id 1596196863444792.7415399916684; Fri, 31 Jul 2020 05:01:03 -0700 (PDT) Received: from localhost ([127.0.0.1] helo=lists.xenproject.org) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1k1TiR-0001KY-0p; Fri, 31 Jul 2020 12:00:47 +0000 Received: from us1-rack-iad1.inumbo.com ([172.99.69.81]) by lists.xenproject.org with esmtp (Exim 4.92) (envelope-from ) id 1k1TiP-0001Jk-Jv for xen-devel@lists.xenproject.org; Fri, 31 Jul 2020 12:00:45 +0000 Received: from chiark.greenend.org.uk (unknown [2001:ba8:1e3::]) by us1-rack-iad1.inumbo.com (Halon) with ESMTPS id 76268c7e-d325-11ea-8e2b-bc764e2007e4; Fri, 31 Jul 2020 12:00:44 +0000 (UTC) Received: from [172.18.45.5] (helo=zealot.relativity.greenend.org.uk) by chiark.greenend.org.uk (Debian Exim 4.84_2 #1) with esmtp (return-path ijackson@chiark.greenend.org.uk) id 1k1TN4-0001W4-8W; Fri, 31 Jul 2020 12:38:42 +0100 X-Inumbo-ID: 76268c7e-d325-11ea-8e2b-bc764e2007e4 From: Ian Jackson To: xen-devel@lists.xenproject.org Subject: [OSSTEST PATCH v2 37/41] cs-bisection-step: temporary table: Insert only rows we care about Date: Fri, 31 Jul 2020 12:38:16 +0100 Message-Id: <20200731113820.5765-38-ian.jackson@eu.citrix.com> X-Mailer: git-send-email 2.20.1 In-Reply-To: <20200731113820.5765-1-ian.jackson@eu.citrix.com> References: <20200731113820.5765-1-ian.jackson@eu.citrix.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-BeenThere: xen-devel@lists.xenproject.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Xen developer discussion List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Cc: Ian Jackson Errors-To: xen-devel-bounces@lists.xenproject.org Sender: "Xen-devel" Content-Type: text/plain; charset="utf-8" Every use of this table has a WHERE or ON which invokes at least one of these conditions. So put only those rows into the table. This provides a significant speedup (which I haven't properly measured). No overall functional change. Signed-off-by: Ian Jackson --- v2: New patch. --- cs-bisection-step | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/cs-bisection-step b/cs-bisection-step index 1c165b78..718c87b0 100755 --- a/cs-bisection-step +++ b/cs-bisection-step @@ -219,7 +219,9 @@ END =20 WHERE t.job =3D ? AND t.flight =3D ? - AND t.name LIKE '%buildjob' + AND t.name LIKE '%buildjob' AND +(@{ $qtxt_common_rev_ok->('b') } OR + @{ $qtxt_common_tree_ok->('b') }) AND b.flight =3D (CASE WHEN t.val NOT LIKE '%.%' THEN t.flight ELSE cast(split_part(t.val, '.', 1) AS i= nt) @@ -239,7 +241,9 @@ END job AS job FROM runvars WHERE job =3D ? - AND flight =3D ? + AND flight =3D ? AND +(@{ $qtxt_common_rev_ok->('runvars') } OR + @{ $qtxt_common_tree_ok->('runvars') }) END =20 my $qtxt_common_results =3D <