From patchwork Tue Mar 17 13:59:16 2020 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Daniel Axtens X-Patchwork-Id: 1256506 Return-Path: X-Original-To: incoming@patchwork.ozlabs.org Delivered-To: patchwork-incoming@bilbo.ozlabs.org Received: from lists.ozlabs.org (lists.ozlabs.org [IPv6:2401:3900:2:1::3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (No client certificate requested) by ozlabs.org (Postfix) with ESMTPS id 48hbp25Wgyz9sTM for ; Wed, 18 Mar 2020 01:55:54 +1100 (AEDT) Authentication-Results: ozlabs.org; dmarc=none (p=none dis=none) header.from=axtens.net Authentication-Results: ozlabs.org; dkim=fail reason="signature verification failed" (1024-bit key; unprotected) header.d=axtens.net header.i=@axtens.net header.a=rsa-sha256 header.s=google header.b=klOhePYK; dkim-atps=neutral Received: from lists.ozlabs.org (lists.ozlabs.org [IPv6:2401:3900:2:1::3]) by lists.ozlabs.org (Postfix) with ESMTP id 48hbp21XdczDqCV for ; Wed, 18 Mar 2020 01:55:54 +1100 (AEDT) X-Original-To: patchwork@lists.ozlabs.org Delivered-To: patchwork@lists.ozlabs.org Authentication-Results: lists.ozlabs.org; spf=pass (sender SPF authorized) smtp.mailfrom=axtens.net (client-ip=2607:f8b0:4864:20::543; helo=mail-pg1-x543.google.com; envelope-from=dja@axtens.net; receiver=) Authentication-Results: lists.ozlabs.org; dmarc=none (p=none dis=none) header.from=axtens.net Authentication-Results: lists.ozlabs.org; dkim=pass (1024-bit key; unprotected) header.d=axtens.net header.i=@axtens.net header.a=rsa-sha256 header.s=google header.b=klOhePYK; dkim-atps=neutral Received: from mail-pg1-x543.google.com (mail-pg1-x543.google.com [IPv6:2607:f8b0:4864:20::543]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by lists.ozlabs.org (Postfix) with ESMTPS id 48hZYC4kjWzDqKg for ; Wed, 18 Mar 2020 00:59:43 +1100 (AEDT) Received: by mail-pg1-x543.google.com with SMTP id y30so11777409pga.13 for ; Tue, 17 Mar 2020 06:59:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=axtens.net; s=google; h=from:to:cc:subject:date:message-id:in-reply-to:references :mime-version:content-transfer-encoding; bh=aVxoxRPgbCBHXskXe11781+OaGz1faHMohAKizKP62I=; b=klOhePYKP4/rSGzC87F7stwYZJDCYYEXDktPt3rfavgaw4t/AACocy/evM7K69g3nQ av0haSurJjGXPZN0n+aDdOtPfasNAptJL35Ra41iJJDboPhBpih2x6FGLnnPy0H9X1ZT CK36+u/JI0hczIkuGbJivKFAif2dL8M5oQj3g= 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:date:message-id:in-reply-to :references:mime-version:content-transfer-encoding; bh=aVxoxRPgbCBHXskXe11781+OaGz1faHMohAKizKP62I=; b=cBSNl38LXRlPI64c6HiVrUbyKXGuBxXQrnPmuxdgkP85N7x3Zh8fZBuqVmHZKeONzd 0S5SZFdsej5AeOJtll5JlkDQhumsnFdkpiJeUNWLC0l/Kt9ll2HxWi2r7KneopvCTGf8 EEr9243plOSn6KlV7m3r99hz4sUl0arTAHlyJZvBSvRRPOWFiORIoRCNnCC/Wrft2fIT WSoMjYXVUC5i6eD8VIosWZyz+gO5JDEKpc2l9RE6LYLa9cVi3BANXVDF1PYaM0aoHPZ0 h9x5TmIXzl5M+9EXE43PVYRLOIcX5OPtcwjvVT+Wh1lkdQufTO5IJ7hbXKp9k/g5lsMB uSaw== X-Gm-Message-State: ANhLgQ3g9Ufgx9YqHJpJ8wGIaUCEzSD6EGirNb74XeZBkctqr7fOJ7A1 1rFDtZPBds27xRM+17N2x/lxSjErzdE= X-Google-Smtp-Source: ADFU+vuXE+Lb0uZfoC0RXGOHwVI+E9SaOMa/GOPtoySK63K0sWmrtFFfjMwAkbc+aKa0Fvy4INr/Ng== X-Received: by 2002:a65:4cc1:: with SMTP id n1mr5038634pgt.94.1584453580303; Tue, 17 Mar 2020 06:59:40 -0700 (PDT) Received: from localhost (2001-44b8-111e-5c00-11e1-e7cb-3c10-05d6.static.ipv6.internode.on.net. [2001:44b8:111e:5c00:11e1:e7cb:3c10:5d6]) by smtp.gmail.com with ESMTPSA id l7sm3376977pff.204.2020.03.17.06.59.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 17 Mar 2020 06:59:39 -0700 (PDT) From: Daniel Axtens To: patchwork@lists.ozlabs.org Subject: [PATCH 4/4] REST: Add release note for faster queries Date: Wed, 18 Mar 2020 00:59:16 +1100 Message-Id: <20200317135916.13691-5-dja@axtens.net> X-Mailer: git-send-email 2.20.1 In-Reply-To: <20200317135916.13691-1-dja@axtens.net> References: <20200317135916.13691-1-dja@axtens.net> MIME-Version: 1.0 X-BeenThere: patchwork@lists.ozlabs.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Patchwork development List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: patchwork-bounces+incoming=patchwork.ozlabs.org@lists.ozlabs.org Sender: "Patchwork" Didn't quite seem like it fit anywhere else in the series. I want the release note mostly because I hope to backport this to stable. Signed-off-by: Daniel Axtens --- .../notes/faster-api-db-queries-a1b5face736fe5b8.yaml | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 releasenotes/notes/faster-api-db-queries-a1b5face736fe5b8.yaml diff --git a/releasenotes/notes/faster-api-db-queries-a1b5face736fe5b8.yaml b/releasenotes/notes/faster-api-db-queries-a1b5face736fe5b8.yaml new file mode 100644 index 000000000000..6c4f6114050f --- /dev/null +++ b/releasenotes/notes/faster-api-db-queries-a1b5face736fe5b8.yaml @@ -0,0 +1,4 @@ +fixes: + - | + Queries to the REST API with filters are now significantly faster: slow + database queries were reworked.