Re: [codesprints] Performance oriented codesprint before IETF 112

Robert Sparks <rjsparks@nostrum.com> Wed, 29 September 2021 22:42 UTC

Return-Path: <rjsparks@nostrum.com>
X-Original-To: codesprints@ietfa.amsl.com
Delivered-To: codesprints@ietfa.amsl.com
Received: from localhost (localhost [127.0.0.1]) by ietfa.amsl.com (Postfix) with ESMTP id 7F2D03A08E7; Wed, 29 Sep 2021 15:42:58 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.08
X-Spam-Level:
X-Spam-Status: No, score=-2.08 tagged_above=-999 required=5 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, NICE_REPLY_A=-0.001, T_SPF_HELO_PERMERROR=0.01, T_SPF_PERMERROR=0.01, URIBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Authentication-Results: ietfa.amsl.com (amavisd-new); dkim=pass (1024-bit key) header.d=nostrum.com
Received: from mail.ietf.org ([4.31.198.44]) by localhost (ietfa.amsl.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Q_7521RvxM1d; Wed, 29 Sep 2021 15:42:54 -0700 (PDT)
Received: from nostrum.com (raven-v6.nostrum.com [IPv6:2001:470:d:1130::1]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id 36D413A08EC; Wed, 29 Sep 2021 15:42:50 -0700 (PDT)
Received: from unformal.localdomain ([47.186.34.206]) (authenticated bits=0) by nostrum.com (8.17.1/8.16.1) with ESMTPSA id 18TMgliF006287 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO); Wed, 29 Sep 2021 17:42:48 -0500 (CDT) (envelope-from rjsparks@nostrum.com)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=nostrum.com; s=default; t=1632955368; bh=SRLAlXpPls9I3QING4oonDx1D8ZiUhY3yKkBNqGkV24=; h=Subject:From:To:Cc:References:Date:In-Reply-To; b=QtJlg3sWLc7tQ8uYez53xgQmWxaclLpotEz6JYEK+1sMyNZt01D4aVEHP2I0xDhFd WLicIt/o0/IqWC5YbEcBXdYCdHlWSYycHIDsPGmb5ZYOtk28Ju3HUwwQxRx2JRV3g5 3hkyyW/yd9ixzkkJ/j69kuPiUb0iyX3zytqeiOIw=
X-Authentication-Warning: raven.nostrum.com: Host [47.186.34.206] claimed to be unformal.localdomain
From: Robert Sparks <rjsparks@nostrum.com>
To: tools-discuss <tools-discuss@ietf.org>
Cc: IETF Codesprints <codesprints@ietf.org>
References: <0d8472cb-179a-fb4c-ff7a-d6ec418b50d4@nostrum.com>
Message-ID: <727700ef-5756-754e-b2e1-61318f7e5275@nostrum.com>
Date: Wed, 29 Sep 2021 17:42:42 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.14.0
MIME-Version: 1.0
In-Reply-To: <0d8472cb-179a-fb4c-ff7a-d6ec418b50d4@nostrum.com>
Content-Type: text/plain; charset="utf-8"; format="flowed"
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/wAaSrUr2tJo36YWU0CSJJH5fiAE>
Subject: Re: [codesprints] Performance oriented codesprint before IETF 112
X-BeenThere: codesprints@ietf.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: "List for coordinating \(and following up on\) codesprint activities" <codesprints.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/codesprints>, <mailto:codesprints-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/codesprints/>
List-Post: <mailto:codesprints@ietf.org>
List-Help: <mailto:codesprints-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/codesprints>, <mailto:codesprints-request@ietf.org?subject=subscribe>
X-List-Received-Date: Wed, 29 Sep 2021 22:42:59 -0000

This time with the link: https://doodle.com/poll/cavrqib4nwdmvuk2

On 9/29/21 5:23 PM, Robert Sparks wrote:
> We would like to hold a codesprint before IETF 112 focused on 
> datatracker performance.
>
> We have been improving the instrumentation of the datatracker, and 
> plan to provide quite a bit of information that will help us focus on 
> places that will help us most. These include statistic from the 
> database engine itself, and instrumentation that measures which views 
> are getting the most use, suffering the worst cumulative performance, 
> and how those views use the database.
>
> I expect much of the work will be verifying that the database has the 
> right indices, adjusting views to make better use of the ORM (such as 
> prefetching data (and not to prefetch too _much_ data), and adjusting 
> models where the current models are proving to be problematic.
>
> I have a doodle for two different possible times on either Oct 27 or 
> Oct 28.
>
> If you would like to participate, please add yourself to the doodle. 
> If the proposed times can't be made to work for you and you would 
> really like to engage in this kind of sprint, please just add a 
> comment at the doodle page.
>
> RjS
>
>
>
>
> _______________________________________________
> codesprints mailing list
> codesprints@ietf.org
> https://www.ietf.org/mailman/listinfo/codesprints