Some slower operations don't respect Virtual Library Restrictions?

Sidetrack · 08-26-2013, 07:48 PM

Sorting on a calculated column, searching a Template, etc... seem to take just as long whether I've restricted things to just a few books or the whole large library. I assume that it's applying the Templates or calculations to all of the books in the library, but it sure would be nice if I could restrict a large library to a Virtual Library containing only the books I'm concerned about so I could, on occasion, speed up a slower process.
To do that now it seems I still have to break things up into Actual Libraries.

kovidgoyal · 08-27-2013, 01:06 AM

IIRC when you do a search with a virtual library applied only the books in that virtual library a re searched (technically the virtual library search is first done, and then the actual search, but the VL search is cached, so effectively, only the actual search is done.)

As for sorting, I think the full library is sorted. It may be possible to change that, but it will take careful coding. Something to look at when I am done fixing all the tiny bugs in 1.0.

EDIT: The above applies only to the new database backend in 1.0. The old backend did no search caching at all.

Sidetrack · 08-27-2013, 07:49 PM

Thank you Kovid, you're on the ball as usual, and sure enough I was wrong. The template search was much quicker in a smaller VL. Must have been multiple updates back when I experienced that.
The sort definitely takes as long with or without a VL. I went ahead and put in a feature request

Sidetrack · 09-08-2013, 10:43 PM

Quote:

Originally Posted by kovidgoyal

As for sorting, I think the full library is sorted. It may be possible to change that, but it will take careful coding. Something to look at when I am done fixing all the tiny bugs in 1.0.

Wow, that was a fast fix, thanks Kovid. The sort is now really fast. It did seem that when I did a bulk metadata update after the sort that it again bogged down into a full database refresh. (I know I can option out of the refresh altogether)

kovidgoyal · 09-08-2013, 10:50 PM

Bulk metadata updates cause a full refresh, that's not going to change, it's not really possible to prevent that short of turning off the updates completely, which you can do via the checkbox.

08-26-2013, 07:48 PM	#1
Sidetrack Enthusiast Posts: 39 Karma: 10 Join Date: Jan 2009 Location: South Pacific Device: Kindle DX	Some slower operations don't respect Virtual Library Restrictions? Sorting on a calculated column, searching a Template, etc... seem to take just as long whether I've restricted things to just a few books or the whole large library. I assume that it's applying the Templates or calculations to all of the books in the library, but it sure would be nice if I could restrict a large library to a Virtual Library containing only the books I'm concerned about so I could, on occasion, speed up a slower process. To do that now it seems I still have to break things up into Actual Libraries.

08-27-2013, 01:06 AM	#2
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	IIRC when you do a search with a virtual library applied only the books in that virtual library a re searched (technically the virtual library search is first done, and then the actual search, but the VL search is cached, so effectively, only the actual search is done.) As for sorting, I think the full library is sorted. It may be possible to change that, but it will take careful coding. Something to look at when I am done fixing all the tiny bugs in 1.0. EDIT: The above applies only to the new database backend in 1.0. The old backend did no search caching at all. Last edited by kovidgoyal; 08-27-2013 at 01:11 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find Duplicates Plugin with Virtual Library	Joan M	Plugins	2	06-01-2013 03:00 AM
Advanced (Maybe?) Virtual Library question?	Dullahir	Calibre	4	05-22-2013 04:12 AM
Creating a virtual library	KoGs	Library Management	1	04-28-2013 05:45 PM
putting virtual books on kobo onto calibre library	apples	Kobo Reader	6	02-23-2013 05:04 PM
Anyone find Reader Library 3.1 to be slower than ****?	sayhello	Sony Reader	5	12-30-2009 11:03 AM

08-27-2013, 07:49 PM	#3
Sidetrack Enthusiast Posts: 39 Karma: 10 Join Date: Jan 2009 Location: South Pacific Device: Kindle DX	Thank you Kovid, you're on the ball as usual, and sure enough I was wrong. The template search was much quicker in a smaller VL. Must have been multiple updates back when I experienced that. The sort definitely takes as long with or without a VL. I went ahead and put in a feature request

09-08-2013, 10:50 PM	#5
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Bulk metadata updates cause a full refresh, that's not going to change, it's not really possible to prevent that short of turning off the updates completely, which you can do via the checkbox.

Advert

Advert