Checking database integrity increased db size
My zotero is running slow. The zotero.sqlite is about 70MB. I checked the db integrity (from preferences/advances). I didn't receive any message error but after that my zotero.sqlite became 5MB heavier. Because I was surprised, I reinstalled the backup zotero.sqlite I made before checking the db and I recheck the db integrity and again, the db increased by 5MB.
Is this normal? Why would my db increase by about 10% when I checked the integrity ? (I was offline the whole time)
Thanks!
Is this normal? Why would my db increase by about 10% when I checked the integrity ? (I was offline the whole time)
Thanks!
-
dstillmanFor complicated reasons, checking database integrity currently also vacuums (rebuilds) the database, which can have an effect on the size. It may speed things up a bit as well. In the future the vacuum will likely happen automatically in the background.
This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.