Thread: [GUI Plugin] Annotations
View Single Post
Old 05-26-2016, 10:16 AM   #261
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by bernard.ryefield View Post
Well, I lost the counts of the changes so I trust you on this one.
From the logs, version 1.4.8 took 4435.8 seconds and 1.4.9 took 3882.9 seconds. Or about 74 and 64 minutes respectively. That's a long time.

Looking at the logs, it is the kepubs. To get the chapter details, a second query is needed. That second query is taking a long time. I have had a look at the queries in use, and have split into two queries. One fetches for the kepubs and the other for the other book types. They get run one after the other and the annotations combined into one list.

This has made a big change here, but it does depend on the calibre library. Before, it was taking about over 40 seconds with either library. Now, I get 5 seconds with one library, and 15 seconds with the other! The slower library has more books on the device, but less books with annotations. The faster has less books, but more books with annotations.

The attached version of the plugin has the change. It is version 1.4.10. It should be a lot faster. But, I'm not expecting it to get under 30 minutes. Hopefully I am wrong.
Attached Files
File Type: zip Annotations-beta.zip (658.6 KB, 470 views)
davidfor is offline   Reply With Quote