switch to large library is slow

[hlhp]

I have a library with about 7000 items.
it will take about 10 seconds switch to it.

sometimes I need switch between libraries frequently,
except from combining libraries, is there a way to make the switch faster?

[BetterRed]

IIRC Custom columns that are a) shown in the book list and b) use the formats_modtimes, formats_paths and formats_sizes template functions can slow things down.

BR

[BetterRed]

Originally Posted by hlhp

I have a library with about 7000 items.
it will take about 10 seconds switch to it.

sometimes I need switch between libraries frequently,
except from combining libraries, is there a way to make the switch faster?

If you refer to Library B without wanting to change its metadata whilst working on Library A, you could use the CalibreSpy plugin which provides read-only access to multiple libraries whilst 'regular' calibre is active ==>> Index of plugins

On Windows the switching between 'regular' calibre and CS windows is done via Desktop switching i.e = Alt+Tab, Win+Tab etc. So it's more or less instant.

BR

[hlhp]

thank you for the respond

after some test, found out the slow performance is caused by have 8 custom columns in the large library.(although all the all the values are fixed values)

I need switch between libraries with cover view, thus CalibreSpy will not fit.

is there a way to keep the library in memory for fast switch?

[BetterRed]

The 'library' is the metadata.db SQLite database which is memory resident when calibre is active. The Author/Title folders are place holders for the actual book content (format) files.

How much RAM do you have?

Are any of the 8 custom columns built from other columns - i.e. do they have have a template.

FWIW - CalbreSpy shows cover if you press Ctrl+I

BR

[hlhp]

I have 16GB ram, it should be sufficient.

you are right, it have 2 columns build from other columns with formula(template?).
after removing this 2 columns, the performance is much better.

I will try out CalbreSpy tomorrow. thank you

[Comfy.n]

I'd suggest generating a debug log with this batch script:
https://www.mobileread.com/forums/sh...63&postcount=2

run script > wait for calibre to load > close calibre > see log generated in the same folder as the .bat file.

this thread got me curious so i just did that... and after looking in the log I found that an emblem formula was calling a deleted custom column, causing some start delay.

deleted the rule > now Calibre loads faster

edit: now that I remembered the "restart in debug mode" option in preferences menu, this seems easier

[theducks]

Originally Posted by hlhp

thank you for the respond

after some test, found out the slow performance is caused by have 8 custom columns in the large library.(although all the all the values are fixed values)

I need switch between libraries with cover view, thus CalibreSpy will not fit.

is there a way to keep the library in memory for fast switch?

I use the Content server with my browser to VIEW other libraries (even on other hosts on my LAN). This may work for you if the intent does not require moving stuff from one to the other

[BetterRed]

Originally Posted by hlhp

you are right, it have 2 columns build from other columns with formula(template?).
after removing this 2 columns, the performance is much better.

If you post the template code the template coding gurus might be able to suggest something to make them faster.

BR

[hlhp]

thank you for all the suggestions.

Just ran the debug and some tests, found out that a template column cause the problem.

I used to the default GUI and need to use the tag browser, CalibreSpy and Content server seems not very good for me.

I will just leave as is, and fix the template column later.