FTS database size?

slantybard · 08-15-2022, 12:41 PM

Is there an estimate of db size for FTS? My calibre library is stored online and I want to estimate how much space the FTS db will take up since I've read in other threads that the db can be GB large. I was wondering if there is an approximate ratio of FTS db size compared to library size that I can expect?

ownedbycats · 08-15-2022, 12:52 PM

It depends on the size of your library, really.

slantybard · 08-15-2022, 01:04 PM

Quote:

Originally Posted by ownedbycats

It depends on the size of your library, really.

Yeah, I figured that. I was wondering if there is an approximate size ratio. ie, if a library is 2 gb and the db would be 1 gb, that would give a ratio of 0.5 - would this then extrapolate to a db size of 2 gb per library size of 4 gb?

I've read threads where people talk about their db being 7+ gb in size which is a large amount of space but then I don't have a reference point on *how* big their library is - is it 1 gb or 100 gb?

Sirtel · 08-15-2022, 01:33 PM

Quote:

Originally Posted by slantybard

Yeah, I figured that. I was wondering if there is an approximate size ratio. ie, if a library is 2 gb and the db would be 1 gb, that would give a ratio of 0.5 - would this then extrapolate to a db size of 2 gb per library size of 4 gb?

I've read threads where people talk about their db being 7+ gb in size which is a large amount of space but then I don't have a reference point on *how* big their library is - is it 1 gb or 100 gb?

This also depends on what formats you have in your library and whether you have high-resolution covers.

The library I indexed for searching is 7.6 GB and the size of the search db is 3.7 GB. In that library I have only epubs, all covers are high quality.

My main library is over 50 GB and I'm not going to index that.

ownedbycats · 08-15-2022, 01:53 PM

Also, I believe Calibre will index every format, so if you convert a lot it'll also increase the size.

slantybard · 08-15-2022, 04:42 PM

Thanks for the responses everyone. I appreciate it.

Comfy.n · 08-17-2022, 04:09 AM

It depends on the kind of files in the library. For instance, too many bulky PDF scanned books will affect the ratio. I gather from this thread that the FTS database size may vary as much as representing just 25% to almost 60% of the total size of the library files, in some cases. A case of a 1:1 ratio has been mentioned, but that seems very unusual.

08-15-2022, 12:41 PM	#1
slantybard my parent's oops... Posts: 492 Karma: 1477572 Join Date: Feb 2009 Device: Vx->Handera->Clie-> Axim->505->650->KPW/Aura ->L2->iOS/CBW	FTS database size? Is there an estimate of db size for FTS? My calibre library is stored online and I want to estimate how much space the FTS db will take up since I've read in other threads that the db can be GB large. I was wondering if there is an approximate ratio of FTS db size compared to library size that I can expect?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
FTS DB maintenance functions?	DrChiper	Calibre	12	07-29-2022 07:34 PM
Aura Database Size on Device	ringo	Kobo Reader	14	12-18-2013 08:02 AM
Calibre Database cp Kindle Database	mitch13	Library Management	1	05-22-2011 07:33 PM
Full size photo size v. Screensaver size?	FF2	Amazon Kindle	5	12-19-2010 11:02 PM

08-15-2022, 12:52 PM	#2
ownedbycats Custom User Title Posts: 10,944 Karma: 74999999 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	It depends on the size of your library, really.

08-15-2022, 01:53 PM	#5
ownedbycats Custom User Title Posts: 10,944 Karma: 74999999 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Also, I believe Calibre will index every format, so if you convert a lot it'll also increase the size.

08-15-2022, 04:42 PM	#6
slantybard my parent's oops... Posts: 492 Karma: 1477572 Join Date: Feb 2009 Device: Vx->Handera->Clie-> Axim->505->650->KPW/Aura ->L2->iOS/CBW	Thanks for the responses everyone. I appreciate it.

08-17-2022, 04:09 AM	#7
Comfy.n want to learn what I want Posts: 1,610 Karma: 7891011 Join Date: Sep 2020 Device: none	It depends on the kind of files in the library. For instance, too many bulky PDF scanned books will affect the ratio. I gather from this thread that the FTS database size may vary as much as representing just 25% to almost 60% of the total size of the library files, in some cases. A case of a 1:1 ratio has been mentioned, but that seems very unusual.

Advert

Advert