Thread: New database backend - testers needed
View Single Post
Old 07-31-2013, 01:44 AM   #90
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 PeterT View Post
@davidfor: with the newest build of calibre here are the logs:
Going through that, the lines I want are:

Code:
146.0 store_current_bookmark - selectedIDs:
159.7 QueueProgressDialog::__init__
166.4 _update_database_columns - start number of reading_locations= 184
166.4 _update_database_columns - setting mi.last_read= None
295.3 _update_database_columns - finished
About 150 seconds elapsed. And about 130 seconds actually update to the library and refreshing the GUI. There isn't enough detail were I want it.
My last run is:

Code:
91.3 store_current_bookmark - selectedIDs
98.3 QueueProgressDialog::__init__
102.2 _update_database_columns - start number of reading_locations= 320
104.9 _update_database_columns - Updating metadata - for column: #kobo_chapteridbookmarked number of changes=320
105.0 _update_database_columns - Updating metadata - for column: #kobo_percentread number of changes=320
109.1 _update_database_columns - Updating metadata - for column: rating number of changes=256
109.1 _update_database_columns - Updating metadata - for column: #kobo_last_read number of changes=320
113.3 _update_database_columns - Updating GUI
113.8 _update_database_columns - finished
Which is 22.5 seconds and about half what I saw with the old db engine.

I have just put a new version up that breaks that last part down and gets rid of some useless messages. It also doesn't show the update prompt.
davidfor is offline   Reply With Quote