Estimating vacuuming database ETA

Geremia · 09-21-2025, 11:13 PM

Why isn't Calibre able to give an estimation (non-"spinning" progress bar) of the time it will take to finish "Vacuuming [the full-text] database to improve performance"?

Does calibredb have a way of checking the status of on ongoing vacuuming?

Or is there another way I can estimate how long it will take?

It took about 12 min. to vacuum a 15G database.

kovidgoyal · 09-21-2025, 11:36 PM

Ask the developers of sqlite

DNSB · 09-22-2025, 03:13 PM

Out of curiosity, what are specs of the computer on which you are vacuuming a 15GB database? On my computer, from clicking Library Maintenance => Check library => Check files takes about 3 minutes with a 17GB full text search database (the metadata.db and calnotes.db file size are pretty much a rounding error in the full-text-search.db file size).

Quoth · 09-23-2025, 12:45 PM

I've never done it before. Running now with 9000+ ebooks and about 14.7G size FTS database.
OS is Linux Mint on 0.5T SSD. A Dell 7050 "lunch box" computer with 8 cores. All of /var (web servers?) and /home (users files) are on a 6T SATA HDD.

Start 16:38 Peak usage about 21% on a random core. HDD light on solid.
End 17:43

09-21-2025, 11:13 PM	#1
Geremia Addict Posts: 262 Karma: 100000 Join Date: Oct 2012 Device: Calibre	Estimating vacuuming database ETA Why isn't Calibre able to give an estimation (non-"spinning" progress bar) of the time it will take to finish "Vacuuming [the full-text] database to improve performance"? Does calibredb have a way of checking the status of on ongoing vacuuming? Or is there another way I can estimate how long it will take? It took about 12 min. to vacuum a 15G database. Last edited by Geremia; 09-21-2025 at 11:16 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I restore the database to backup? - database disk image is malformed	lumping-sugar66	Kobo Reader	7	09-10-2024 11:57 AM
local HTML files (reading progress, add info for database)	tentakel	Kobo Reader	2	06-20-2023 02:24 PM
Vacuuming the Kobo database	ownedbycats	Kobo Reader	1	02-26-2021 07:50 PM
Progress bar: this unknown. (chapter progress)	gabryele	Kobo Reader	23	12-14-2019 06:02 PM
Color Anyone ever make any progress hacking the Nook's database?	mwheinz	Nook Developer's Corner	1	02-14-2012 08:15 AM

09-21-2025, 11:36 PM	#2
kovidgoyal creator of calibre Posts: 45,544 Karma: 28548962 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Ask the developers of sqlite

09-22-2025, 03:13 PM	#3
DNSB Bibliophagist Posts: 47,575 Karma: 172313954 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	Out of curiosity, what are specs of the computer on which you are vacuuming a 15GB database? On my computer, from clicking Library Maintenance => Check library => Check files takes about 3 minutes with a 17GB full text search database (the metadata.db and calnotes.db file size are pretty much a rounding error in the full-text-search.db file size).

09-23-2025, 12:45 PM	#4
Quoth Still reading Posts: 14,725 Karma: 109269703 Join Date: Jun 2017 Location: Ireland Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper	I've never done it before. Running now with 9000+ ebooks and about 14.7G size FTS database. OS is Linux Mint on 0.5T SSD. A Dell 7050 "lunch box" computer with 8 cores. All of /var (web servers?) and /home (users files) are on a 6T SATA HDD. Start 16:38 Peak usage about 21% on a random core. HDD light on solid. End 17:43