Good evening, I am trying to insert 5.4 million rows to a sqlite database
running in Windows or Unix/Linux. I am using a transaction to try to speed up
the insertions. When the sqlite database is accessed by multiple connections,
and one of the processes modifies the database, the SQLite database is locked
until that transaction is committed. As a result, I periodically get a sqlite
return code of 1 from sqlite3_step after inserting one of the 5.4 million rows.
I am running Process Explorer on windows to see if another user or process has
a connection to the sqlite database table.
The Process explorer tells me my executable is the only process with
connections to the sqlite database. The database locking problem is causing me
to skip insertions. I would like to verify if my executable does indeed have
multiple connections to the sqlite database. Is there a sqlite API does can
tell me how many open connections my executable is responsible for? Also, it is
possible to determine the lines of code(i.e like a gdb backtrace) in my
application are responsible for each of the multiple connection? Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
