There is no multi threading. Just a single thread and only one
connection/handle.
While iterating through the resultset I am also trying to execute an update
for every row. Along the lines of:
resultset = db.exec(`select`)
foreach row in resultset {
db.exec(`update`)
}
I don't want to read the whole resultset into memory.
After a lot of searching and trial and error I found that
PRAGMA journal_mode=WAL
seems to do the trick.
I don't fully understand why though.
cheers,
Torsten
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
