On 18 Jul 2015, at 6:37am, Hayden Livingston <halivingston at gmail.com> 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. > > Removing PRAGMA from my INSERT statements brings back the performance. > > Any ideas? Try playing with the other two: PRAGMA encoding = "UTF-8"; PRAGMA encoding = "UTF-16"; PRAGMA encoding = "UTF-16le"; PRAGMA encoding = "UTF-16be"; you might figure out whether your programming language is using 'le' or 'be' internally. If that doesn't help ... Which OS ? If your OS has codepages or other ways of specifying charactersets, which characterset do you use in your programming language ? Simon.
