Speed up database access
Posted: Tue Apr 09, 2013 12:09 am
I noticed for one person, executing an sqlite update statement was slowing down with time (up to 10ms per update query). They were on an SSD, so not a slow drive, and restarting Mudlet would give the expected speeds again. After some Googling, I found the PRAGMA synchronous option, which upon setting to off, seemed to fix this. It could be some weird win8/sqlite interaction or just win8 being buggy, not certain. Either way, if you run into this, doing this seems to be workaround (at the dangers of data loss, please read the link to know what you're doing first).
This is only for user-made databases made with db:! Not Mudlets map database (which doesn't use sqlite) or anything else.