Trouble with importing *.db files

[Pete Kovalenko]

My problem: after importing "Mnemosyne 2.x *.db files" only active cards of the source .db are imported (which is nice), nevertheless the destination .db bloats enormously, as if the entire source .db was imported.

I merged my own .db and my daughter's .db into one file so we now do our repetitions together, which is fun. But I kept adding new cards to my old .db in order to get them a little more mature, to correct mistakes, to add sounds/pictures/videos etc before transferring them to our main .db file. I was adding ≈200 new cards a week. Did it weekly for 3 or 4 weeks and noticed that Mnemosyne became real slow for some reason. Checked the .db file, and it was huge -- 133 Mb. "Compact Database" command didn't do much. For the sake of experiment I left only 2 cards active (out of more than 19000) and imported this huge .db into my old personal .db -- and now its size is 137 Mb (with only 55 cards in it). What should I do? ("Compact Database" command doesn't do much to the size of these files.) (my Mnemosyne version is 2.3.5)

[Pete Kovalenko]

I opened the .db file in SQLite Manager and deleted the entire contents of the "log" table. I no longer have the past statistics, but at least the .db file is small again. Problem solved.

[Peter Bienstman]

Hi,

 

If you upgrade to the latest version, ‘compact database’ has an option to archive the old logs, which would have achieved the same thing, but without data loss J

 

Cheers,

 

Peter

--
You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mnemosyne-proj-u...@googlegroups.com.
To post to this group, send email to mnemosyne-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/487c88d0-cd27-4c44-befb-5cfd98519754%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.