Quote:
Originally Posted by ownedbycats
Aside from it probably being unnecessary, is there any reason not to compress the Kobo database once a day or thereabouts? I've gotten into the habit of doing it.
|
Strictly, it won't harm anything but, it is probably a waste of time.
A compress is only likely to be useful if there are a lot of changes. And it is more likely to be useful after a lot of deletes. SQLite will claim space but doesn't release it. But, it will reuse it. So, if you add ten books, the database file will grow. If you remove ten books, the file won't shrink and space in it will be marked as free. If you then add a book, it will should use the space that was free for the new book details. The compress will be useful to release the free space and hence get a smaller database file. But, it should also reorganise the tables and indexes. That might help with performance.
The other side of it is that every time you do something, there is risk. If you do the compress frequently, it is more likely you will hit whatever bug there is or the time you accidentally knock the cable out at exactly the wrong time.