From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id qHjfMXjajGMjbgAAbAwnHQ (envelope-from ) for ; Sun, 04 Dec 2022 18:35:52 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id +OwHMXjajGNEAQEAG6o9tA (envelope-from ) for ; Sun, 04 Dec 2022 18:35:52 +0100 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 6DD4B4676 for ; Sun, 4 Dec 2022 18:35:52 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1p1stK-0008G1-13; Sun, 04 Dec 2022 12:35:02 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1p1stI-0008FU-Bt for emacs-orgmode@gnu.org; Sun, 04 Dec 2022 12:35:00 -0500 Received: from mail-pg1-x52f.google.com ([2607:f8b0:4864:20::52f]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1p1stG-0007o2-PW for emacs-orgmode@gnu.org; Sun, 04 Dec 2022 12:35:00 -0500 Received: by mail-pg1-x52f.google.com with SMTP id 6so8549157pgm.6 for ; Sun, 04 Dec 2022 09:34:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=tMai0wfgefXwQL559YSsSxks1XFUnJkC+aYnCNtG/OQ=; b=Dp2GNFGomN2qSSdU8OuYeeG4U5Ta1J+2WQZUdM2t1GXWxgWZOf5KRAdYrRedJyQAGB 1vuTNV1nboHYW93yWoQWVV2CaIfj5ELyvC60I3mcT/4Yjyn7V6NQaYtAqi5GuTijfHtq /tE7JhwIR+wujcLvg79N5urDmooBJa+OjwutxsnHVbuql4RjKSpixfe/ONo1YkSz1E5b oKgxsN/o87bElkmbLWpUbdPNY8ydgwGBgxBu+gUO0T+QbKiSdkwea7O0VwFBLxnD8PtT vjZmY+UVYX5HCGbhZdYY8jpGdq4m6kXuv3GAn74pBVyE3SzV9kiWWUZ2sw+N2F+thWm2 FGnA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=tMai0wfgefXwQL559YSsSxks1XFUnJkC+aYnCNtG/OQ=; b=7Np02sdKPLajEzc942SdBNgxtfgck2+JaqtVOPsNm3af+bbcMdsZXuVbQz9ZqcgBGs ZdqQqoQhUoSdngabzYhoOMmuI3XWU5A4OLgCwzIEy8HAYv2ELKyygRmfBr786X3YMKYB 3cl78jE7E0c/JKoshzWybp6Qc2Cv7azKrvpC5tYNIHblufHUWQYzRdNbKf9NwLGQbgpQ 3lNYZF5ddqFO9pMWIs8cQUZnXSvqZuVSPCIJI/agAs/+xOnEyuoSSQn7YRfei2CwbtbA Ft8BndmlTOX/3nYNrJK536618WBsEum3Qn5UeoMIRZWHow0jsTk6W4yBlRC43o0u3PQn GADg== X-Gm-Message-State: ANoB5pkItZ3u5vj99fZsXnoACn3X4J5fnXhY76HvP+fAmahZL3ycpNZ1 dCa7WqPrv0r7cQe3C6FKLPU= X-Google-Smtp-Source: AA0mqf4VMYhGZU8/qOVGanbqksmINQ4AQ8UkwL9vgzs+74GtiXnd3Zoy9K3YKKBSv1DCJSnymxv8JA== X-Received: by 2002:a63:4449:0:b0:477:a5e2:7b78 with SMTP id t9-20020a634449000000b00477a5e27b78mr51417937pgk.322.1670175296690; Sun, 04 Dec 2022 09:34:56 -0800 (PST) Received: from smtpclient.apple (2603-8001-7a00-01a0-79aa-5590-4160-f2a2.res6.spectrum.com. [2603:8001:7a00:1a0:79aa:5590:4160:f2a2]) by smtp.gmail.com with ESMTPSA id z6-20020a1709027e8600b00189caf296e6sm2527440pla.279.2022.12.04.09.34.55 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 04 Dec 2022 09:34:56 -0800 (PST) From: Mark Barton Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_6101EDB0-657E-4E38-BC8F-F84E6D681F03" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.1\)) Subject: Re: Clocking in is pretty slow in version 9.6 when the item has a large Date: Sun, 4 Dec 2022 09:34:54 -0800 In-Reply-To: Cc: emacs-orgmode@gnu.org To: Eli Qian References: X-Mailer: Apple Mail (2.3696.120.41.1.1) Received-SPF: pass client-ip=2607:f8b0:4864:20::52f; envelope-from=mbarton98@gmail.com; helo=mail-pg1-x52f.google.com X-Spam_score_int: -17 X-Spam_score: -1.8 X-Spam_bar: - X-Spam_report: (-1.8 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1670175352; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=tMai0wfgefXwQL559YSsSxks1XFUnJkC+aYnCNtG/OQ=; b=LUST1DGn4IhvmH7KG1BfdJTv65NSWmbBagccHKbK/25kXdmDpYbhN6ZwNAs58+Wz+Roznv UxIM6Ibh6qyuBhu2Op6oZgO3nVi1cTFtCs5MVk/NGI1ONOYyB9DEZyfR1XHyTzFTXkAyQY hui9Ygi1vlln4SaiiXN4o80R0RhvFjyQ/GyC2QWcfkcfNyVglAmIsAj7hf870bSUe+StjU 54vDbliykAH7gqaDE+CT6ovwpv4EinsOdiqvz7t+RNaKj/WmVZXjrFV2ZDjzJ2RJWx/QUU m41WRx4W1MgAKO3hS4KshBqAsD0tq6fHMp3RRPCWBcJGO7HcRpseGM9j95yUVQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1670175352; a=rsa-sha256; cv=none; b=BRahNMjkMp6aa6uYwVO1W0A8bTt0icCOdRKAnJhE5aHz4o/xDMDmSljGdBvmllmqf2fyyb wNxTuzdgh5vjGKl5bVobN9yVnvTAyrJkI6ug9aZPGoJTffY4JDeBykyy3F6+kubDT2xp2q nCIB/JWmwsERGO77TVTwVV2JqeNySup4MzlcwWCbf0LmO5UCGo9++CSmPCrND7nl4fDVFB 7i3mA5K1qhTMUdal8k9Y6K5le4EAud2bzAIychGlJgmhoyGrU9njq6Q0GwxC8oMGSpHOkg FCiGR3+KLEz9QI5nvL1HF5YyuSg7QRV6O47VHig4a1MKMDWf/sbzEG3qfKGyEA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=Dp2GNFGo; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -1.96 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=Dp2GNFGo; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 6DD4B4676 X-Spam-Score: -1.96 X-Migadu-Scanner: scn0.migadu.com X-TUID: yv5jgzRd7Y9z --Apple-Mail=_6101EDB0-657E-4E38-BC8F-F84E6D681F03 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > On Dec 4, 2022, at 4:12 AM, Eli Qian wrote: >=20 > After investigation by using profiler, I found the problem is caused = by > `org-element-at-point` I'm also seeing this slowdown after compliling from Emacs master around = the time of the 29.1 cutoff. I use the org version in Emacs master. I = use clocktable reports that scope a two week period to calculate the = time spent on tasks. Normally the update to the table takes maybe = 10s-30s, but lately it takes over 3 minutes to run. Emacs 30.0.50 (Build 21G115) of 2022-12-02 Org mode version release_9.6-3-ga4d38e @ = /Applications/Emacs.app/Contents/Resources/lisp/org/ Emacs -Q Open org file with clocking data and find the clocktable line as shown = below. C-c C-c to update the clocktable report. #+BEGIN: clocktable :scope file :maxlevel 6 :link nil :tstart = "[2022-11-19 Sat 00:00]" :tend "[2022-12-03 Sat 11:00]" :formula % :step = day :stepskip0 t This took over 3 minutes to run. If I use an older build I have as my "stable" version for testing... Emacs 29.0.50 (Build 21F79) of 2022-08-05 Org mode version 9.5.4-17-g6e991f=20 then the same clocktable line takes 11s to update. Mark= --Apple-Mail=_6101EDB0-657E-4E38-BC8F-F84E6D681F03 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii

On Dec 4, 2022, at 4:12 AM, Eli Qian <eli.q.qian@gmail.com> wrote:

After investigation by using = profiler, I found the problem is caused by
`org-element-at-point`

I'm also seeing this slowdown after = compliling from Emacs master around the time of the 29.1 cutoff. I use = the org version in Emacs master. I use clocktable reports that scope a = two week period to calculate the time spent on tasks. Normally the = update to the table takes maybe 10s-30s, but lately it takes over 3 = minutes to run.

Emacs 30.0.50 (Build 21G115) of 2022-12-02
Org mode version release_9.6-3-ga4d38e @ = /Applications/Emacs.app/Contents/Resources/lisp/org/
Emacs  -Q
Open org file with = clocking data and find the clocktable line as shown below. C-c C-c to = update the clocktable report.

#+BEGIN: clocktable = :scope file :maxlevel 6 :link nil :tstart "[2022-11-19 Sat 00:00]" :tend = "[2022-12-03 Sat 11:00]" :formula % :step day :stepskip0 = t

This = took over 3 minutes to run.

If I use an older build I have as my "stable" version for = testing...
Emacs 29.0.50 (Build 21F79) of = 2022-08-05
Org mode version = 9.5.4-17-g6e991f 
then the same clocktable = line takes 11s to update.

Mark
= --Apple-Mail=_6101EDB0-657E-4E38-BC8F-F84E6D681F03--