I searched the forum already and tried every posted solution including:
Deleting large decks then performing check database.
Exporting decks then re-importing them.
Using Clean disconnect review logs.
Emptying the trash can of media.
Searching for ‘base64’ cards.
My problem is that ankiweb reports a collection size of 246mb with many decks deleted already. This already lead to an error when trying to sync.
I installed the note-size addon, and it reports a raw text size of 66.7mb which seems way more realistic. Still the collection size report 246mb.
Using the note size addon I also don’t see any cards that are unusually large looking at either the raw text size nor the overall size.
Could you help me in identifying where this amount of data comes from so I can import my currently exported decks once again and sync?
Most likely the revlog table is taking up a lot of space. That is all the reviews you have ever done, including from cards/notes you deleted. For reference, I have more than 500mb with just the reviews alone (several million reviews).
Perhaps you might want to delete the reviews from deleted cards, or reschedules (time=0), etc.
So, the revlog which is stored within collection.anki2 can’t be larger than 66Mb.
Looks like, there is another problem on the AnkiWeb side.
Maybe, it’s just a delay in updating the size in AnkiWeb interface.
perhaps you have a ton of graves, that is another possibility. I suggest running a collection check, and later installing DQ browser (sqlite) to actually see the contents
If you have added and deleted tons of stuff, which is what I imagine being that you have 100k cards, it is likely the case of graves. Or hundreds of thousands of reschedules, which will be in revlog table with time=0
Thanks for the heads up, but I stayed clear from deleting review history on cards I acitvely use. I only really started using anki from september on, so everything beforehand was safe to delete.
I think it is save to delete reschedules. Anki after a certain version logged the reschedules adding a time or 0 milliseconds. Once you switch to FSRS for instance and resched all your cards that can quickly add many entries in the revlog.
Yep had this in head already but now proceeded with it. Turns out that the largest amount comes from the Ankizin deck which adds a whopping 140mb. With a few other decks installed and a few months of review history the limit is promptly reached. I will send the creators this thread and see if something can be done about it.
It’s very, very, very unusual for a young collection like yours to have a database of that size based on revlog entries. 20K revlog entries is a bit high for only a few months’ of use, but not outlandishly so. Have you been using FSRS “reschedule cards on change” frequently?
Have you run Tools > Check Database again since you started deleting things from the database? [Manually editing your database is always more risky than not doing that, so better to save that for a last-resort.]
But 100K notes is a lot. Have you taken a look at Note Size again since it caught up with reality (I assume it was having a caching issue before)? If you sort by the “Size (texts)” column, especially on that Ankizin deck, you might be able to narrow in on the culprits. Look for exceptional amounts of hidden HTML/CSS formatting in those notes.
