As mentioned in my post, sqlite3 is only able to read 2% of the file. I know how to extract the strings but sqlite splits individual memos into multiple blocks and spreads them out over the file. This makes it very difficult to find the entire contents of specific memos.
I was hoping there is a tool that understands sqlite format and could repair the bad section so I can extract more than 2%.
A quick google check shows that there is no such tool. You can try "pragma integritycheck;" and ".dump"
Anyone care to venture a guess why my tablet is running super chunky?
It keeps freezing for minutes at a time on me.
I also see that there is like 5 maemo launcher thingies that are constantly running.
Did you try rebooting it?
Try terminating each program one by one and see if the sluggishness goes away. Unless of course it is slow immediately after boot.
It is common to many instances of maemo-launcher, ignore them. But that one instance that is consuming 133m virtual could be a problem. Try killing it. I also notice you have tear running and browserd, do you use microb? If you don't use microb you can prevent browserd from starting to free up some memory.
You probably also have a bunch of sites open in tear, judging by the virtual memory it is using. Javascript heavy sites can slow down the tablet, try disabling javascript and using mobile friendly URLs for the sites.