I'm working on a project written in C that generates almost 350k sequences to be persisted on a sqlite database. For each sequence I have to insert (or ignore) a string in a table and update a row in other table.
I tried this "guide" but couldn't reach more than 30k operations per second.
I'm using transactions of 1M operations each (inserts and updates) and PRAGMA synchronous=OFF
What options do I have to solve this bottleneck?