On 3 Nov 2017, at 9:35pm, Lev <leventel...@gmail.com> wrote:

> I call these function at each INSERT:
> sqlite3_prepare_v2(sq3, query, -1, &sq3_stmt, NULL);
> sqlite3_step(sq3_stmt);
> sqlite3_finalize(sq3_stmt);
> query holds the INSERT SQL.
> The question is what can I do to speed up the INSERT proces? The database is
> also opened by other processes, so I want to lock the table as short time as I
> can.

Those two are in conclict.  You might like to try putting BEGIN … END around 
your inserts just for testing.

sqlite-users mailing list

Reply via email to