MobileRead Forums - View Single Post

Adoby · 12-15-2013, 09:22 AM

I expect that calibre could handle several 100K entries without serious problems, if you use some care.

Things that can slow down calibre a lot is if you use custom columns, based on other columns. Or things like rules to color fields. Or if you have a formats column that is based on checking the formats of the actual ebooks. Or if you have the tag browser open if not needed.

By default I believe that the formats displayed now use information stored in the database, about the books, and not actually check the book files when calibre is started. That can be very slow. But if you have been using calibre for a while your installation may use the old method.

You can read more about this in this now a bit old thread:

https://www.mobileread.com/forums/sho....php?p=2244745

Since that thread was started calibre has gotten a new database backend that has made calibre much faster in many cases. The problems that I used to have, and that caused me to start that thread, are now mostly gone. But I still don't have any computed custom columns and I use approximate format and I have the database on a SSD drive using symlinks and temp in RAM...

Also you may be able to split your calibre library into two or three separate libraries. That might also help.

For instance Fiction and Nonfiction. And perhaps Unsorted for new/incoming books that you haven't fixed metadata for, or need to fix other things for.

* Remove any columns you don't actually use, especially if they depend on other columns.
* Check to make sure that the formats column is based on approximate format and not actual format.
* Hide the tag browser when you don't use it.
* Add more memory to the computer.

12-15-2013, 09:22 AM	#2
Adoby Handy Elephant Posts: 1,737 Karma: 26785684 Join Date: Dec 2009 Location: Southern Sweden, far out in the quiet woods Device: Samsung Galaxy Tab S8 Ultra	I expect that calibre could handle several 100K entries without serious problems, if you use some care. Things that can slow down calibre a lot is if you use custom columns, based on other columns. Or things like rules to color fields. Or if you have a formats column that is based on checking the formats of the actual ebooks. Or if you have the tag browser open if not needed. By default I believe that the formats displayed now use information stored in the database, about the books, and not actually check the book files when calibre is started. That can be very slow. But if you have been using calibre for a while your installation may use the old method. You can read more about this in this now a bit old thread: https://www.mobileread.com/forums/sho....php?p=2244745 Since that thread was started calibre has gotten a new database backend that has made calibre much faster in many cases. The problems that I used to have, and that caused me to start that thread, are now mostly gone. But I still don't have any computed custom columns and I use approximate format and I have the database on a SSD drive using symlinks and temp in RAM... Also you may be able to split your calibre library into two or three separate libraries. That might also help. For instance Fiction and Nonfiction. And perhaps Unsorted for new/incoming books that you haven't fixed metadata for, or need to fix other things for. * Remove any columns you don't actually use, especially if they depend on other columns. * Check to make sure that the formats column is based on approximate format and not actual format. * Hide the tag browser when you don't use it. * Add more memory to the computer. Last edited by Adoby; 12-15-2013 at 10:32 AM.