Thread: Kobo future firmware feature request thread
View Single Post
Old 09-15-2021, 09:54 AM   #2025
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 koboy View Post
i did mention it in my first post. (4897) 99% of which are kepubs and a few epubs no pdfs. i also mentioned all my books are on the external micro SD card. there isn't a internal SD card in the original Aura 6"
Firstly, I'm honestly surprised that your Aura stopped working with a 1GB databases. Considering it only has 256MB of RAM and no swap space, I'm surprised it didn't stop working a lot earlier. The database is read when the device starts and at least the structure for the book details is loaded. If that doesn't fit into the RAM, then the device is either continuously opening the database or just won't work properly.

But, are you sure about the number of books? 4897 books taking more than 1GB of database seems wrong. On my Clara HD I have about 9000 books and the database is about 180MB. The books are a mix of ePubs and kepubs with less than 100 books of other formats. But, the bulk of the database will be the entries for the books plus the ToC entries.

The bulk of the database will be the content table. This has one entry per book, plus entires for navigation. In general, the navigation entries are the ToC entries for the for format. But, there is always at least on. And for kepubs, there is one per manifest entry and one per ToC entry.

With that, the bigger the ToCs, the longer the descriptions, titles and author names, then the bigger the database. But, as I said, your database size to number of books seems off. The stats for my Clara HD are probably lower than average as it has a lot of short stories. The average number of ToC entries is 16 whereas the Libra H2O has about 900 books with an average of 82 ToC entries. That database is 87MB.

The other places that could take space in the database are the Bookmark and Event tables. You would need to have made a lot of annotation for the former to take much space. The Event table can have several rows per book that you have opened. So the space taken depends on how much you have actually read. And, to a certain extent, how you read.
davidfor is offline   Reply With Quote