MobileRead Forums - View Single Post - Touch kobo touch freezes for few seconds randomly after firmware downgrade

ashadul · 10-12-2014, 02:13 AM

I was experimenting with my kobo touch to find out the cause of freezing problem and these are so far my findings:

1. Previously kobo used to save images on file system and now inside the database. This increase the database file size drastically. Disabling cover view on book list and compacting the sqlite database improves performance.

2. Kobo is keeping various activity logs in the database further increasing the database size. Manually deleting the logs and compacting helps.

3. Reducing the no of books in the device and compacting helps even more.

These cases makes me believe that database structure change without consideration to impact is the reason my freezing. (I hate to think inefficient SQL queries is the reason behind my problem though I made the same mistake once.)

Any thoughts?

10-12-2014, 02:13 AM	#9
ashadul Junior Member Posts: 6 Karma: 10 Join Date: May 2014 Device: Kobo Touch	Observation on my Kobo Touch freezing issue I was experimenting with my kobo touch to find out the cause of freezing problem and these are so far my findings: 1. Previously kobo used to save images on file system and now inside the database. This increase the database file size drastically. Disabling cover view on book list and compacting the sqlite database improves performance. 2. Kobo is keeping various activity logs in the database further increasing the database size. Manually deleting the logs and compacting helps. 3. Reducing the no of books in the device and compacting helps even more. These cases makes me believe that database structure change without consideration to impact is the reason my freezing. (I hate to think inefficient SQL queries is the reason behind my problem though I made the same mistake once.) Any thoughts?