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

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page Estimating vacuuming database ETA

Notices

Reply
 
Thread Tools Search this Thread
Old 09-22-2025, 12:13 AM   #1
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 263
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-22-2025 at 12:16 AM.
Geremia is offline   Reply With Quote
Old 09-22-2025, 12:36 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,617
Karma: 28549044
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Ask the developers of sqlite
kovidgoyal is offline   Reply With Quote
Advert
Old 09-22-2025, 04:13 PM   #3
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 48,294
Karma: 174315444
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).
DNSB is offline   Reply With Quote
Old 09-23-2025, 01:45 PM   #4
Quoth
Still reading
Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.
 
Quoth's Avatar
 
Posts: 15,040
Karma: 111111255
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
Quoth is offline   Reply With Quote
Old 11-06-2025, 01:25 PM   #5
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 263
Karma: 100000
Join Date: Oct 2012
Device: Calibre
Question What's in the calnotes.db database?
Quote:
Originally Posted by DNSB View Post
calnotes.db
What's stored in that database?
Geremia is offline   Reply With Quote
Advert
Old 11-06-2025, 03:22 PM   #6
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 48,294
Karma: 174315444
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Annotations and highlights IIRC.
DNSB is offline   Reply With Quote
Old 11-06-2025, 05:17 PM   #7
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: 22,033
Karma: 30277294
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by DNSB View Post
Annotations and highlights IIRC.
Nope - it contains the 'Notes' that can be attached to category items - authors, tags, publishers, series etc.

BR
BetterRed is offline   Reply With Quote
Reply

Tags
database, full text

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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 12:57 PM
local HTML files (reading progress, add info for database) tentakel Kobo Reader 2 06-20-2023 03:24 PM
Vacuuming the Kobo database ownedbycats Kobo Reader 1 02-26-2021 08:50 PM
Progress bar: this unknown. (chapter progress) gabryele Kobo Reader 23 12-14-2019 07:02 PM
Color Anyone ever make any progress hacking the Nook's database? mwheinz Nook Developer's Corner 1 02-14-2012 09:15 AM


All times are GMT -4. The time now is 04:43 AM.

Contact Us - FAQ - Guidelines - Privacy - Top

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