Estimating vacuuming database ETA

Geremia · Yesterday, 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 · Yesterday, 11:36 PM

Ask the developers of sqlite

DNSB · Today, 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).

Yesterday, 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; Yesterday 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

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

Today, 03:13 PM	#3
DNSB Bibliophagist Posts: 47,508 Karma: 171313058 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).

Advert