zotero.sqlite
Is it possible that using the Zotero Database Repair Tool would speed up Zotero even if my zotero.sqlite has no errors in the database?
Also, a previous version of my zotero.sqlite was 800+kb, while my current version with the same number of items (around 5000) is only 52kb. Is that due to the change from Zotero 3 to 4, or is there some other explanation?
Also, a previous version of my zotero.sqlite was 800+kb, while my current version with the same number of items (around 5000) is only 52kb. Is that due to the change from Zotero 3 to 4, or is there some other explanation?
52MB would be a typical size for a database your size. 800+MB would be quite extraordinary.
No, database changes since 2.1 shouldn't affect database size much - a major factor is the amount of indexed full text, so this can vary quite a bit even with the same number of items.
Not 100% sure about speed, but I doubt it. What's the background?
The background is that I found the application SpeedyFox which seemed to speed up my Firefox performance by compacting/rebuilding the sqlite files (and maybe some other things too; I'm not sure). So, I was just wondering if Zotero would benefit from something similar.