3 ms·
AFAICS you're doing all your inserts in a single transaction, unlike the article. Using transactions is better for performance, but probably less representativ
by wmanley 4y ago
AFAICS you're doing all your inserts in a single transaction, unlike the article. Using transactions is better for performance, but probably less representative in this specific case.
- andrewstuart 4y agoTrue. A commit on every insert would definitely crush your performance. That's one of the worst ways to do bulk inserts. Really the whole thing is kind of pointless because there are so many factors. It's not about the language, it's more about sqlite and its configuration.