Quote:
Originally Posted by BetterRed
Yes, I thought of that after I posted. The OP mentioned a "mm_annotations" custom column, which I see is also long text. I suggest he excludes that column too.
|
Tried that... no dice. The annotations aren't that long, they just include highlighted passages (maybe 4 max per book), and they're only present in 10-20 books.
Quote:
Originally Posted by BetterRed
Since we're talking about Virtual Library switching and we've eliminated most everything else, my suspicions have fallen on the VL search expressions, mine are simple. I guess there are performance implications if they're complex.
|
Switching virtual libraries/VL tabs is instantaneous. What hangs is the loading of the VM View. For example, I'll click on a VL tab, immediately be able to see all the listed books, but it's still showing the column setup of the VM View from the previous library; then I'll wait a few seconds and
then the correct columns for that Virtual Library's VM view kick in. The lag happens when switching between VM Views in the All Books tab, too.
All my search expressions are simple:
- not #vendor:"=AO3" not tags:"=Manga"
- tags:"Manga"
- #vendor:"AO3"
I've run a ton of tests in the portable version: loaded a copy of my current library, tried removing all kinds of columns and metadata, tried creating smaller new libraries from scratch and adding custom columns to those, then making different VM views...
The fastest setup was when I dropped 25 eBook files directly into a new, clean library; didn't add any custom columns; made some VM views. Switching between those VM views was fast. Not instant, but faster than a second.
I also tried making a new library and importing my full original library (with settings) into it, then deleting all but 30 books. Still slow. A
little faster than my original install, but still a couple of seconds.
Honestly I'm driving myself a bit batty with all the testing, so I'm probably just going to give up and live with it.
I really appreciate everyone's help and suggestions, though!