Re: [BUG] LOGBOOK makes property search (in org-agenda) too slow(?)

2022-03-13 Thread Ihor Radchenko 


Samuel Wales  writes:
> are there intereim workarounds like semi-automatically moving large
> logbook entries, or entire logbooks, to a task that says "was logbook
> for ..." and then archiving that task?  or automatically archiving old
> logbook entries?

My largest logbook contains ~2.5k clock records with no obvious impact
on performance (on main). However, when I was using older Org versions,
I used the following helper functions:

Credit: 
https://www.reddit.com/r/orgmode/comments/dg43hs/can_i_archive_a_property_drawer/f3frk2n/
Caveat: you might get duplicate IDs using the functions below. I just
changed the archived ID manually in the past.

#+begin_src emacs-lisp
(defun my/org-archive-delete-logbook ()
  (save-excursion
   (org-end-of-meta-data)
   (let ((elm (org-element-at-point)))
 (when (and
(equal (org-element-type elm) 'drawer)
(equal (org-element-property :drawer-name elm) "LOGBOOK"))
   (delete-region (org-element-property :begin elm)
  (org-element-property :end elm))

(defun my/org-archive-without-delete ()
  (cl-letf (((symbol-function 'org-cut-subtree) (lambda () nil)))
(org-archive-subtree)))

(defun my/org-archive-logbook ()
  (interactive)
  (my/org-archive-without-delete)
  (my/org-archive-delete-logbook))
#+end_src

Best,
Ihor

Re: [BUG] LOGBOOK makes property search (in org-agenda) too slow(?)

2022-03-12 Thread Samuel Wales 
are there intereim workarounds like semi-automatically moving large
logbook entries, or entire logbooks, to a task that says "was logbook
for ..." and then archiving that task?  or automatically archiving old
logbook entries?


On 3/12/22, Ihor Radchenko  wrote:
> "fr...@t-online.de"  writes:
>
>> I have just one headline and do a simple property search (prop1="blah1")
>> for the 'org-agenda', but this takes about 10 seconds!
>
> Thanks for providing a reproducible example! We know about this
> performance issue. Performance has been improved in the development
> version of Org (not released yet). Using your example, agenda generation
> is instant on main.
>
> Best,
> Ihor
>
>


-- 
The Kafka Pandemic

A blog about science, health, human rights, and misopathy:
https://thekafkapandemic.blogspot.com

Re: [BUG] LOGBOOK makes property search (in org-agenda) too slow(?)

2022-03-12 Thread Ihor Radchenko 
"fr...@t-online.de"  writes:

> I have just one headline and do a simple property search (prop1="blah1") 
> for the 'org-agenda', but this takes about 10 seconds! 

Thanks for providing a reproducible example! We know about this
performance issue. Performance has been improved in the development
version of Org (not released yet). Using your example, agenda generation
is instant on main.

Best,
Ihor

Re: [BUG] LOGBOOK makes property search (in org-agenda) too slow(?)

2022-03-12 Thread Milan Zamazal 
> "fmd" == fr ml@t-online de  writes:

fmd> I have just one headline and do a simple property search
fmd> (prop1="blah1") for the 'org-agenda', but this takes about 10
fmd> seconds!

Org versions from recent years don’t like large logbooks and don’t like
large files.  For agenda, org-super-agenda & org-ql provide solution,
they are generally much faster, don’t suffer from the logbook problem
and are also much powerful.

For other purposes, it can be more difficult.  For example, I had to
split my single org-drill file into multiple smaller files when editing
and using the file became unusable due to Org slowness in some new Org
version.  The increasing Org slowness is a limiting factor (and perhaps
the only limiting factor) of what can be done with Org.

Regards,
Milan

[BUG] LOGBOOK makes property search (in org-agenda) too slow(?)

2022-03-12 Thread fr...@t-online.de 
Hello,

I have just one headline and do a simple property search (prop1="blah1") 
for the 'org-agenda', but this takes about 10 seconds! 
--- FILE: 
* empty item but with a long logbook
:PROPERTIES:
:prop1: blah1
:END:
:LOGBOOK:
CLOCK: [2022-03-12 Sat 05:05]--[2022-03-12 Sat 05:24] => 0:19
CLOCK: [2022-03-11 Fri 20:50]--[2022-03-11 Fri 21:20] => 0:30
CLOCK: [2022-03-11 Fri 17:13]--[2022-03-11 Fri 17:25] => 0:12
CLOCK: [2022-03-11 Fri 06:10]--[2022-03-11 Fri 06:30] => 0:20
CLOCK: [2022-03-10 Thu 23:14]--[2022-03-11 Fri 00:25] => 1:11
CLOCK: [2022-03-10 Thu 16:45]--[2022-03-10 Thu 17:07] => 0:22
CLOCK: [2022-03-10 Thu 05:19]--[2022-03-10 Thu 06:30] => 1:11
CLOCK: [2022-03-09 Wed 22:29]--[2022-03-09 Wed 22:35] => 0:06
CLOCK: [2022-03-09 Wed 16:45]--[2022-03-09 Wed 17:01] => 0:16
CLOCK: [2022-03-12 Sat 05:05]--[2022-03-12 Sat 05:24] => 0:19
CLOCK: [2022-03-11 Fri 20:50]--[2022-03-11 Fri 21:20] => 0:30
CLOCK: [2022-03-11 Fri 17:13]--[2022-03-11 Fri 17:25] => 0:12
CLOCK: [2022-03-11 Fri 06:10]--[2022-03-11 Fri 06:30] => 0:20
CLOCK: [2022-03-10 Thu 23:14]--[2022-03-11 Fri 00:25] => 1:11
CLOCK: [2022-03-10 Thu 16:45]--[2022-03-10 Thu 17:07] => 0:22
CLOCK: [2022-03-10 Thu 05:19]--[2022-03-10 Thu 06:30] => 1:11
CLOCK: [2022-03-09 Wed 22:29]--[2022-03-09 Wed 22:35] => 0:06
CLOCK: [2022-03-09 Wed 16:45]--[2022-03-09 Wed 17:01] => 0:16
CLOCK: [2022-03-09 Wed 05:20]--[2022-03-09 Wed 06:30] => 1:10
CLOCK: [2022-03-08 Tue 22:15]--[2022-03-08 Tue 22:30] => 0:15
CLOCK: [2022-03-08 Tue 16:10]--[2022-03-08 Tue 16:23] => 0:13
CLOCK: [2022-03-12 Sat 05:25]--[2022-03-12 Sat 06:40] => 1:15
CLOCK: [2022-03-12 Sat 05:10]--[2022-03-12 Sat 05:24] => 0:14
CLOCK: [2022-03-11 Fri 20:45]--[2022-03-11 Fri 21:25] => 0:40
CLOCK: [2022-03-11 Fri 16:00]--[2022-03-11 Fri 16:30] => 0:30
CLOCK: [2022-03-11 Fri 06:05]--[2022-03-11 Fri 06:40] => 0:35
CLOCK: [2022-03-12 Sat 06:38]--[2022-03-12 Sat 06:40] => 0:02
CLOCK: [2022-03-12 Sat 05:05]--[2022-03-12 Sat 05:24] => 0:19
CLOCK: [2022-03-11 Fri 20:50]--[2022-03-11 Fri 21:20] => 0:30
CLOCK: [2022-03-11 Fri 17:13]--[2022-03-11 Fri 17:25] => 0:12
CLOCK: [2022-03-11 Fri 06:10]--[2022-03-11 Fri 06:30] => 0:20
CLOCK: [2022-03-10 Thu 23:14]--[2022-03-11 Fri 00:25] => 1:11
CLOCK: [2022-03-10 Thu 16:45]--[2022-03-10 Thu 17:07] => 0:22
CLOCK: [2022-03-10 Thu 05:19]--[2022-03-10 Thu 06:30] => 1:11
CLOCK: [2022-03-09 Wed 22:29]--[2022-03-09 Wed 22:35] => 0:06
CLOCK: [2022-03-09 Wed 16:45]--[2022-03-09 Wed 17:01] => 0:16
CLOCK: [2022-03-09 Wed 05:20]--[2022-03-09 Wed 06:30] => 1:10
CLOCK: [2022-03-08 Tue 22:15]--[2022-03-08 Tue 22:30] => 0:15
CLOCK: [2022-03-08 Tue 16:10]--[2022-03-08 Tue 16:23] => 0:13
CLOCK: [2022-03-12 Sat 05:25]--[2022-03-12 Sat 06:40] => 1:15
CLOCK: [2022-03-12 Sat 05:05]--[2022-03-12 Sat 05:24] => 0:19
CLOCK: [2022-03-11 Fri 20:50]--[2022-03-11 Fri 21:20] => 0:30
CLOCK: [2022-03-11 Fri 17:13]--[2022-03-11 Fri 17:25] => 0:12
CLOCK: [2022-03-11 Fri 06:10]--[2022-03-11 Fri 06:30] => 0:20
CLOCK: [2022-03-10 Thu 23:14]--[2022-03-11 Fri 00:25] => 1:11
CLOCK: [2022-03-10 Thu 16:45]--[2022-03-10 Thu 21:07] => 4:22
CLOCK: [2022-03-10 Thu 05:19]--[2022-03-10 Thu 06:30] => 1:11
CLOCK: [2022-03-09 Wed 22:29]--[2022-03-09 Wed 22:35] => 0:06
CLOCK: [2022-03-09 Wed 16:45]--[2022-03-09 Wed 17:01] => 0:16
CLOCK: [2022-03-09 Wed 05:20]--[2022-03-09 Wed 06:30] => 1:10
CLOCK: [2022-03-08 Tue 22:15]--[2022-03-08 Tue 22:30] => 0:15
CLOCK: [2022-03-08 Tue 16:10]--[2022-03-08 Tue 16:23] => 0:13
CLOCK: [2022-03-12 Sat 05:25]--[2022-03-12 Sat 06:40] => 1:15
CLOCK: [2022-03-12 Sat 05:10]--[2022-03-12 Sat 05:24] => 0:14
CLOCK: [2022-03-11 Fri 20:45]--[2022-03-11 Fri 21:25] => 0:40
CLOCK: [2022-03-11 Fri 16:00]--[2022-03-11 Fri 16:30] => 0:30
CLOCK: [2022-03-11 Fri 06:05]--[2022-03-11 Fri 06:40] => 0:35
CLOCK: [2022-03-12 Sat 06:38]--[2022-03-12 Sat 06:38] => 0:00
CLOCK: [2022-03-12 Sat 05:05]--[2022-03-12 Sat 05:24] => 0:19
CLOCK: [2022-03-11 Fri 20:50]--[2022-03-11 Fri 21:20] => 0:30
CLOCK: [2022-03-11 Fri 17:13]--[2022-03-11 Fri 17:25] => 0:12
CLOCK: [2022-03-11 Fri 06:10]--[2022-03-11 Fri 06:30] => 0:20
CLOCK: [2022-03-10 Thu 23:14]--[2022-03-11 Fri 00:25] => 1:11
CLOCK: [2022-03-10 Thu 16:45]--[2022-03-10 Thu 17:07] => 0:22
CLOCK: [2022-03-10 Thu 05:19]--[2022-03-10 Thu 06:30] => 1:11
CLOCK: [2022-03-09 Wed 22:29]--[2022-03-09 Wed 22:35] => 0:06
CLOCK: [2022-03-09 Wed 16:45]--[2022-03-09 Wed 17:01] => 0:16
CLOCK: [2022-03-09 Wed 05:20]--[2022-03-09 Wed 06:30] => 1:10
CLOCK: [2022-03-08 Tue 22:15]--[2022-03-08 Tue 22:30] => 0:15
CLOCK: [2022-03-08 Tue 16:10]--[2022-03-08 Tue 16:23] => 0:13
CLOCK: [2022-03-12 Sat 05:25]--[2022-03-12 Sat 06:40] => 1:15
CLOCK: [2022-03-12 Sat 05:05]--[2022-03-12 Sat 05:24] => 0:19
CLOCK: [2022-03-11 Fri 20:50]--[2022-03-11 Fri 21:20] => 0:30
CLOCK: [2022-03-11 Fri 17:13]--[2022-03-11 Fri 17:25] => 0:12
CLOCK: [2022-03-11 Fri 06:10]--[2022-03-11 Fri 06:30] => 0:20
CLOCK: [2022-03-10 Thu 23:14]--[2022-03-11 Fri 00:25] => 1:11
CLOCK: [2022-03-10 Thu 16:45]--[2022-03-10 Thu 17:07]