On 2 Sep 2016, at 8:52am, Simon Lepasteur <[email protected]> wrote:
> I have multiple processes accessing the same database file (sqlite 3.8.7.4
> on linux). The DB contains only one table and every process execute
> prepared statements (sqlite3_prepare_v2) like the following one:
>
> INSERT INTO table (process,type,status,occurence,data)
> VALUES('test',2,2,1472800896400,'{"key1":"value","key2":"value"}')
What are the replies to
PRAGMA journal_mode
PRAGMA integrity_check
PRAGMA busy_timeout
at the time you're executing your INSERT commands ? You don't need to report
these when an error has happened, just tell us what they are set to normally.
Are you executing any PRAGMAs in your program which change any modes, so any
speedups, etc. ?
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
