From nobody Mon Feb 9 15:10:11 2026 Delivered-To: importer@patchew.org Authentication-Results: mx.zohomail.com; dkim=fail; spf=none (zoho.com: 192.237.175.120 is neither permitted nor denied by domain of lists.xenproject.org) 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=1573239100; cv=none; d=zoho.com; s=zohoarc; b=nGxShv+51vmDJEUzxt0vqi4OC3Y8XNCA3+cecwFQVOsD674Um/uen8tHckSBmAt8aDiRB+r2LJb45WjVC9F2ZWs1p4kVbzugUAJVPNe4Ufs3hLaX8sswNXmeBpxPQp6RJXWN9sWW1gnemRx/deosIpoNakWMRpRP80KpgkDofY0= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zoho.com; s=zohoarc; t=1573239100; h=Content-Type: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=9BHtqTQ3nftTbd+x5q6iseCPzYpHChnxQwpnk3UgLCI=; b=KMtMFE22xEUYNt4jiLCk6lMcAJQJx07z5DMqyTHgpjcnhaf2nL9GDu2o1/rWnUSVHT0EahAtHtktDo6BMuU4UfFHwIhJ7R26lynaruFhddbtKS3L+JZ/B89NoC/ISpuRgY3OM76egP16nqbLsQTn3bz+FZh5n+CcuhpSAj0NLws= ARC-Authentication-Results: i=1; mx.zoho.com; dkim=fail; spf=none (zoho.com: 192.237.175.120 is neither permitted nor denied by domain of lists.xenproject.org) 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 1573239100036824.0189859533953; Fri, 8 Nov 2019 10:51:40 -0800 (PST) Received: from localhost ([127.0.0.1] helo=lists.xenproject.org) by lists.xenproject.org with esmtp (Exim 4.89) (envelope-from ) id 1iT9LG-00082D-RY; Fri, 08 Nov 2019 18:50:42 +0000 Received: from us1-rack-iad1.inumbo.com ([172.99.69.81]) by lists.xenproject.org with esmtp (Exim 4.89) (envelope-from ) id 1iT9LF-000816-Hu for xen-devel@lists.xenproject.org; Fri, 08 Nov 2019 18:50:41 +0000 Received: from esa5.hc3370-68.iphmx.com (unknown [216.71.155.168]) by us1-rack-iad1.inumbo.com (Halon) with ESMTPS id 9a517026-0258-11ea-9631-bc764e2007e4; Fri, 08 Nov 2019 18:50:16 +0000 (UTC) X-Inumbo-ID: 9a517026-0258-11ea-9631-bc764e2007e4 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=citrix.com; s=securemail; t=1573239016; h=from:to:cc:subject:date:message-id:in-reply-to: references:mime-version; bh=W6m5wYP8ekZTDoQ/zPFavOw8FePgmmvJpG/O6zLNBKk=; b=VS7FaCSGG3TEVpszh08WKHn5LiQc3rQ626iqQEI0Dil4iY3CUwZBpK/Y Kd2S0I82FQfoLDz4WOWymli6jQjnZKq/A7hTs+cv7YlXtCEbxZC+exvzk g55WH9tp3vSqzrtgIA1I/QNC/8fsDXw3jpk/LvV7XCiCQLE5lo4FVMamX 8=; Authentication-Results: esa5.hc3370-68.iphmx.com; dkim=none (message not signed) header.i=none; spf=None smtp.pra=ian.jackson@eu.citrix.com; spf=Pass smtp.mailfrom=Ian.Jackson@citrix.com; spf=None smtp.helo=postmaster@mail.citrix.com Received-SPF: none (zoho.com: 192.237.175.120 is neither permitted nor denied by domain of lists.xenproject.org) client-ip=192.237.175.120; envelope-from=xen-devel-bounces@lists.xenproject.org; helo=lists.xenproject.org; Received-SPF: None (esa5.hc3370-68.iphmx.com: no sender authenticity information available from domain of ian.jackson@eu.citrix.com) identity=pra; client-ip=162.221.158.21; receiver=esa5.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="ian.jackson@eu.citrix.com"; x-conformance=sidf_compatible Received-SPF: Pass (esa5.hc3370-68.iphmx.com: domain of Ian.Jackson@citrix.com designates 162.221.158.21 as permitted sender) identity=mailfrom; client-ip=162.221.158.21; receiver=esa5.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="Ian.Jackson@citrix.com"; x-conformance=sidf_compatible; x-record-type="v=spf1"; x-record-text="v=spf1 ip4:209.167.231.154 ip4:178.63.86.133 ip4:195.66.111.40/30 ip4:85.115.9.32/28 ip4:199.102.83.4 ip4:192.28.146.160 ip4:192.28.146.107 ip4:216.52.6.88 ip4:216.52.6.188 ip4:162.221.158.21 ip4:162.221.156.83 ip4:168.245.78.127 ~all" Received-SPF: None (esa5.hc3370-68.iphmx.com: no sender authenticity information available from domain of postmaster@mail.citrix.com) identity=helo; client-ip=162.221.158.21; receiver=esa5.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="postmaster@mail.citrix.com"; x-conformance=sidf_compatible IronPort-SDR: AJRExs/14f51KprXrXfsw1FSOntMkl3TlPRA+dbgx5BhzuvFg58aMi/AwlLJtMm9WaJ7K+N/dG nYi5PjDO/J+oMHZkR5UBsDg/pEe7MSHH5TURT5V4PHuwhkWcci40XUzrzjaBixoWv+zzXrszp3 VeRt1zEe8Fl4SjtMcLwYXGCyrOq3GlQat6YKDnGIRqYyzHX8eCmuGies2juVA8mTYGasiAFdpx Mdb91exej2CTsi1Uba++EScgEEtkKVZj+vq4gsiYwY9YrYRKYH0/1gSJQqNnLgtUnBOPp7tgAe 0U0= X-SBRS: 2.7 X-MesageID: 8429296 X-Ironport-Server: esa5.hc3370-68.iphmx.com X-Remote-IP: 162.221.158.21 X-Policy: $RELAYED X-IronPort-AV: E=Sophos;i="5.68,283,1569297600"; d="scan'208";a="8429296" From: Ian Jackson To: Date: Fri, 8 Nov 2019 18:49:52 +0000 Message-ID: <20191108185001.3319-5-ian.jackson@eu.citrix.com> X-Mailer: git-send-email 2.11.0 In-Reply-To: <20191108185001.3319-1-ian.jackson@eu.citrix.com> References: <20191108185001.3319-1-ian.jackson@eu.citrix.com> MIME-Version: 1.0 Subject: [Xen-devel] [OSSTEST PATCH 04/13] sg-report-host-history: Actually honour $minflight X-BeenThere: xen-devel@lists.xenproject.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Xen developer discussion List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Cc: Ian Jackson Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Errors-To: xen-devel-bounces@lists.xenproject.org Sender: "Xen-devel" X-ZohoMail-DKIM: fail (Header signature does not verify) This seriously speeds up some of the queries. Signed-off-by: Ian Jackson --- sg-report-host-history | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/sg-report-host-history b/sg-report-host-history index fc51074d..d47784d9 100755 --- a/sg-report-host-history +++ b/sg-report-host-history @@ -67,6 +67,7 @@ while (@ARGV && $ARGV[0] =3D~ m/^-/) { =20 our $restrictflight_cond =3D restrictflight_cond(); our $flightcond; +our $minflight; =20 sub computeflightsrange () { if (!$flightlimit) { @@ -100,7 +101,7 @@ END LIMIT 1 END $minflightsq->execute(); - my ($minflight) =3D $minflightsq->fetchrow_array(); + ($minflight,) =3D $minflightsq->fetchrow_array(); $minflight //=3D 0; =20 $flightcond =3D "(flight > $minflight)"; @@ -127,10 +128,12 @@ sub mainquery () { AND ($valcond) AND $flightcond AND $restrictflight_cond + AND flight > ? ORDER BY flight DESC LIMIT ($limit * 3 + 100) * ? END =20 + push @params, $minflight; push @params, scalar keys %hosts; =20 print DEBUG "MAINQUERY...\n"; --=20 2.11.0 _______________________________________________ Xen-devel mailing list Xen-devel@lists.xenproject.org https://lists.xenproject.org/mailman/listinfo/xen-devel