Author Topic: Database Compression.  (Read 3227 times)

rasmith1959

  • Newbie
  • *
  • Posts: 7
Database Compression.
« on: November 18, 2013, 05:58:25 pm »
I've been using AquaMail for several months and discovered the Compress Database menu item. So my question is exactly what does it do? Also how often should one use this, and what are the signs that one needs to compress the database?


Sent from my Nexus 7 (2013) using Tapatalk 4.

Kostya Vasilyev

  • Hero Member
  • *****
  • Posts: 12740
Re: Database Compression.
« Reply #1 on: November 25, 2013, 01:59:13 am »
On some devices, the performance of SQLite database built into Android significantly degrades over time.

I guess it has to do with hardware more than anything else, and none of my devices (new and old) exhibit this.

If the app's UI performance gets really slow, such as opening a folders' message list taking 15 seconds or longer (yes, it really does get that slow), then that's a good reason to run the compression.

Other than that, the app already does nightly maintenance of its database, trimming old data, and asking SQLite to perform incremental garbage collection.
Creating debug logs for diagnostics: https://www.aqua-mail.com/troubleshooting/

The official FAQ: https://www.aqua-mail.com/faq/

Лог-файлы для диагностики: https://www.aqua-mail.com/ru/troubleshooting/

Вопросы и ответы: https://www.aqua-mail.com/ru/faq/