Vacuuming the Kobo database

ownedbycats · 02-26-2021, 04:45 AM

Is there any benefit of using VACUUM on KoboReader.sqlite?

davidfor · 02-26-2021, 07:50 PM

Yes, but, whether it will actually be noticeable is another thing.

It will only be useful if the internal structure has become fragmented. That is most likely to happen if you were adding a removing a lot of books. And the device does a VACUUM at some points (don't ask me when). Any time I have done it recently, it has only recovered a few megabytes of data. There was a time when it could easily recover 50% of the space used, but, Kobo changed some options used for the database and it isn't as noticeable now. Or the VACUUMs it does keep it under control.

02-26-2021, 04:45 AM	#1
ownedbycats Custom User Title Posts: 10,876 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Vacuuming the Kobo database Is there any benefit of using VACUUM on KoboReader.sqlite?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Kobo Glo] Updated firmware→Calibre:"Kobo database version unsupported"	22217	Devices	10	06-25-2020 07:02 PM
Aura ONE How to move database from Kobo Aura One to Kobo Forma	codychan	Kobo Reader	1	11-07-2018 05:56 AM
Kobo database	Stevex	Kobo Developer's Corner	4	12-16-2016 09:21 PM
Glo Kobo glo and calibre 1.25.0 : kobo database version not suported ?	gperrot	Kobo Reader	2	07-13-2014 10:24 AM
Kobo desktop v1.7.5 corrupts database on original Kobo	Greenmantle	Kobo Reader	5	11-24-2010 07:23 PM

02-26-2021, 07:50 PM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Yes, but, whether it will actually be noticeable is another thing. It will only be useful if the internal structure has become fragmented. That is most likely to happen if you were adding a removing a lot of books. And the device does a VACUUM at some points (don't ask me when). Any time I have done it recently, it has only recovered a few megabytes of data. There was a time when it could easily recover 50% of the space used, but, Kobo changed some options used for the database and it isn't as noticeable now. Or the VACUUMs it does keep it under control.

Advert