Thread: Forma Large Database Question
View Single Post
Old 12-18-2020, 10:02 AM   #6
93terp
Fear The Turtle!
93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.
 
93terp's Avatar
 
Posts: 868
Karma: 4067244
Join Date: Sep 2009
Location: Margaritaville
Device: KV, Kobo Forma, Kobo A1LE, KO3, K3
Quote:
Originally Posted by davidfor View Post
That seems a bit big. I have about 8000 books on my Clara HD and the database is a little 200MB. Though that is 80% epub, which has less records in the database. But, I wouldn't expect it to be 4 times as much space. But, it will also depend on the length of the comments/synopsis for the book and if you are making annotations.

You could try compressing the database. That should reduce the size, but, the amount will depend on how fragmented the database is. If you are a calibre user, my Kobo Utilities plugin has this as a function. Or you can use any SQLite database manager to do it. And I would recommend taking a backup of the database before doing this.

If you logout of the Kobo account, the database is removed and a new one created when you login again. Then the sideloaded books will be imported again. You will lose any annotations, reading status and collections for these books. Again, if you are a calibre user, some of these can be restored afterwards.

Could I ask that when you do either of the above, that you post the new database size. I'm curious about how much these steps actually help.
I don't have comments, I don't have annotations, I don't have notes or highlights, just the books. And 100% of them are kepubs (conversion to kepub on the sideload from Calibre).

I've used your database compression tool many times. But at this point it's not resulting in much of a noticeable reduction in the size of the database.

Will absolutely post the database before & after sizes later today. Plan to do the login/logout on my Forma shortly.
93terp is offline   Reply With Quote