MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page Is it possible to specify a different location for matadata.db?

Notices

Reply
 
Thread Tools Search this Thread
Old 10-26-2024, 03:35 AM   #1
elPedr0
Member
elPedr0 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Oct 2022
Device: none
Is it possible to specify a different location for matadata.db?
Is it possible to specify a different location for metadata.db, other than the root folder of the library?
elPedr0 is offline   Reply With Quote
Old 10-26-2024, 03:43 AM   #2
elPedr0
Member
elPedr0 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Oct 2022
Device: none
Think I've found the answer to my question. It looks to be possible with environment variables.
https://manual.calibre-ebook.com/customize.html
elPedr0 is offline   Reply With Quote
Advert
Old 10-26-2024, 05:26 AM   #3
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 79,683
Karma: 145864619
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by elPedr0 View Post
Is it possible to specify a different location for metadata.db, other than the root folder of the library?
You can. But I don't see any reason to have metadata.db in another location.
JSWolf is offline   Reply With Quote
Old 10-26-2024, 05:37 AM   #4
capink
Wizard
capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.
 
Posts: 1,195
Karma: 1995558
Join Date: Aug 2015
Device: Kindle
For a laptops with both SDD/NVMe and HDD, if your library is large and cannot fit into SDD, putting the metadata.db alone on SDD can provide a performance boost.
capink is offline   Reply With Quote
Old 10-26-2024, 07:27 AM   #5
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,712
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by capink View Post
For a laptops with both SDD/NVMe and HDD, if your library is large and cannot fit into SDD, putting the metadata.db alone on SDD can provide a performance boost.
Very marginal boost - I had it on 300GB 100K+ 'book' library full of AV clips and transcripts - no discernible difference. Main advantage was when the library was on an external USB drive I could view the library as a catalogue even though the USB was powered down. IIRC I could even edit metadata; the lazy writes would happen when the USB came back on line and I switched to that library.

It's now on an internal 4TB SATA 3.3 drive. If I start calibre on that library (now over 150K 'books') its ready in under 5 secs - which is 1-2 secs longer than opening the default library with one book, one format, and no custom columns.

BR
BetterRed is offline   Reply With Quote
Advert
Old 10-26-2024, 10:36 AM   #6
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,031
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
My whole Library is on the Spinning Rust part (a mounted volume on C: (the SSD) . Just Use the Create/Switch: Move the current library to new location that is a choice on the Library Icon.
AFAIK the DB is kept in RAM while using, so other than transfer rate on load, there is no speed to be gained. RAM... Lots of fast RAM ... is the way to go

I bought a Refurbed Dell Optiplex i7 that had 16G RAM, 780M SSD and 2T HD and a fresh W10 Pro

When I decided to check on drive usage I only had under 1T available.
The System had never been configured for the HD... At all. It was there, spinning, but had not even been enabled in the BIOS.
I guessed on how to set up a hybrid as I could not quickly find a 'proper' configuration tutorial
theducks is offline   Reply With Quote
Old 10-27-2024, 06:00 PM   #7
elPedr0
Member
elPedr0 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Oct 2022
Device: none
Quote:
Originally Posted by JSWolf View Post
You can. But I don't see any reason to have metadata.db in another location.
I've come round to this way of thinking. I'll keep the db in the default location. TY.
elPedr0 is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Library Database location vs Library location (nas) sshaikh Calibre 1 02-01-2023 07:02 PM
display custom matadata Gardenman Library Management 2 12-21-2021 06:19 PM
Go to Location joenojunk Kindle Formats 0 07-16-2013 02:33 PM
Matadata management for Kindle CaitlinShaw Calibre 2 01-17-2011 09:40 PM
What exactly is a location rcuadro Amazon Kindle 19 03-26-2009 10:48 AM


All times are GMT -4. The time now is 11:19 AM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.