Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 12-12-2021, 02:50 AM   #1
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,973
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Lag after removing a column

Previously, I had two reading status columns: #read (tristate boolean) and #percentread (integer).

I recently updated all the templates I could find (column icons, composite columns, and some action chains) to check for a 0 or 100 in the integer column instead of true/false in the bool. All seemed to be well so I deleted the boolean column. Now Calibre is lagging every time I update a column.

I put back the boolean column and the lag went away completely.

My best guess is that I missed a template somewhere and it's trying to update based on the nonexistent column, but I can't figure out where it might be -- I scoured all my composite columns, and as far as I understand column icon rules remove themselves when invalid.

For now, just to kill the lag I just created a composite that returns 'yes' for 100 and 'no' for 0.

Any other idea where I should check?

Last edited by ownedbycats; 12-12-2021 at 03:19 AM.
ownedbycats is offline   Reply With Quote
Old 12-12-2021, 03:47 AM   #2
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,973
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
I ended up using SQLiteStudio to make a dump of my database so that I could use Notepad++ to search for the column name. (Except Notepad++ didn't like the size of it, so I ended up using EmEditor instead.)

I'd left a #read in a saved search used in one of my virtual libraries. And from there a composite column checking virtual_libraries(). Oh, and a column icon checking the virtual library column. That would probably do it. I changed it and the lag's gone.

Last edited by ownedbycats; 12-12-2021 at 04:08 AM.
ownedbycats is offline   Reply With Quote
Advert
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange Lag Note2. Anyone else? dkccerbero Onyx Boox 6 12-07-2020 09:47 PM
Do you have an issue with the 'lag' between page turning? derball2008 General Discussions 50 07-10-2014 10:01 PM
iPad Some Issues Of Reported Lag With IOS7? robertc88 Apple Devices 24 10-09-2013 03:16 AM
Sony PRS-650 Lag capslock Sony Reader 3 11-21-2010 05:43 PM
Stylus + screen lag? curiouser iRex 1 07-27-2006 02:49 PM


All times are GMT -4. The time now is 10:11 PM.


MobileRead.com is a privately owned, operated and funded community.