Thread: Forma Large Database Question
View Single Post
Old 12-17-2020, 08:15 PM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by 93terp View Post
I have what seems to be an incredibly large Kobo database (800+MB for approximately 6,500 kepubs). All of my books are sideloaded. If I log out of my Kobo account and log back in, will I have to resend everything back to my Forma? Or will the login/logout just rebuild the database while maintaining my books on the device?
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.
davidfor is offline   Reply With Quote