Offtopic but related to your comment: yesterday I merged my revlog from all my profiles to check the new calendar graph in 2.1.28 (I missed 5 days in total !). Just the revlog with an empty collection is 289MB, so above 250MB.
Did you use Tools>Check Database before checking the size? That will shrink the database down to its minimum size.
2 Likes
Yes indeed 648MB before 289MB after. After doing some math, each milion reviews roughly weights 64-65MB.
If you run the following in the debug console then close Anki, you may be able to squeeze out a bit more space savings
e=mw.col.db.execute
mw.col.save(trx=False)
e("pragma page_size=4096")
e("pragma journal_mode=delete")
e("vacuum")
mw.col.db.begin()
If you’ve clocked up close to 4 million reviews, I am very impressed - you’re only the second user I’ve come across with such a large amount of studying. I ended up recommending to the other person that they back up their collection (so the old history is not lost), then remove review history from more than a few years back to keep the collection size manageable.
4 Likes
As of now, 4.6 m reviews closer to 4.7.
I got this error:
Traceback (most recent call last):
File "aqt\main.py", line 1396, in onDebugRet
File "<string>", line 2, in <module>
TypeError: save() got an unexpected keyword argument 'trx'That code requires 2.1.28
Ok, about 11MB less.