On 7/18/2015 1:37 AM, Hayden Livingston wrote: > I then switched to UTF-8 thinking it's the increased writes causing > it, no noticeable difference, i.e. it's just as slow as PRAGMA=UTF-16.
Note that "PRAGMA encoding" only has effect before the database is created - that is, right after you open a connection to a file that doesn't exist yet, and before you issue a CREATE TABLE or similar statement on that connection. Once the file is created, its encoding is set in stone and cannot be changed. Further invocations of "PRAGMA encoding" are silently ignored. So when you say you "switched to UTF-8" - you probably haven't. -- Igor Tandetnik
