View Single Post
Old 03-11-2013, 11:49 AM   #4
GeoffR
Wizard
GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.
 
GeoffR's Avatar
 
Posts: 3,821
Karma: 19162882
Join Date: Nov 2012
Location: Te Riu-a-Māui
Device: Kobo Glo
Quote:
Originally Posted by davidfor View Post
Changing the calibre save template is a simple way to slow down reaching the limit. The default is "{author_sort}/{title} - {authors}", so changing to "{author_sort}/{title}" would reduce the length of the name a lot without losing much info in the name.
I have set the template to {author_sort[0]}/{author_sort:list_item(0,\,)}, {title} to save a bit of space, only the surname of the first author is used. I think this would let me have about 3000-3500 books.

I am thinking about using {author_sort[0]}/{id} so each filename is just the Calibre library ID, which would allow about 5400 books.

Quote:
An alternative would be to rename the image files and update the database to match. Dropping "file..." prefix would save a bit. That wouldn't be to hard to automate. Or maybe a database trigger on insert?
Something along those lines would be nice as an option. Do you think using shorter names would help reduce the database size, or are the fields padded out to fill a fixed size?

Last edited by GeoffR; 03-11-2013 at 11:50 AM. Reason: punctuation
GeoffR is offline   Reply With Quote