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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users