Quote:
Originally Posted by davidfor
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.
|
thank you for this detailed explanation i do appreciate you taking the time to do it. i can assure you i do have 4897 books in total on my Aura taking up 12.7GB of space on my 32GB external micro SD card. i do however have a lot of Bookmarks so perhaps that may account for my large 1GB database.
i can restore the user partition/database from my last backuo which as 4888 books on it (9 books less) with Firmware 4.25.15875 on it and the Aura powers on and off fine and works 100% ok. if i restore my last backup and delete all the unnecessary Bookmarks and then compact/vacuum the database do you think it will make the database noticeably smaller?
best wishes koboy
