Large collections

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.

1 Like

Did you use Tools>Check Database before checking the size? That will shrink the database down to its minimum size.

1 Like

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.