Mybases 8 export to directory tree has been good enough to get my data out, after some additional folder renaming and tweaking. My usage has been mostly of saved web pages, in snippets or as a whole.
Laurent, technically, I understand SQLite may handle a lot, but as an ordinary Joplin user it is inherently impractical and wasteful to me to keep sync of 10GB of storage for a mere 450 of web pages and snippets. That's a 20-fold increase from the other app's storage needs, for just keeping the same actual content. I'm now looking into the costs of hundred(s) of GB of cloud storage for things that are actually taking less than 3 GB in my local disk. That isn't an overhead I'm comfortable with no further reasoning. Hope in the future the team my find better ways of storing web pages.
At glance, the bulk of the storage seems related to things that shouldn't concern my kind of usage (i.e. saving web pages). The question is now, how to slim ITEM_CHANGES, REVISIONS (and perhaps also NOTES_FTS_SEGMENTS) way down?
No, never, but made many import > delete all entries > import again attempts, while trying to get the import right. Also got Joplin unresponsive a couple of times and reinstalled twice. Let me try the JEX export and start clean to see what may improve. Thanks!
Exported my stuff to JEX and the archive clocked up at 1.1GB, which is about the exact size of the stuff exported from mybase. Removed Joplin and C:\Users\USER\.config\joplin-desktop\*.* that includes database.sqlite; reinstalled fresh and imported the JEX archive back. The import finished with database.sqlite at about 1.8GB, which is quite an improvement, but it continued to grow afterwards and it's now at 2.8GB. Hope it stays there, I need no more indexing.
3a8082e126