Hello,
I was thinking about a possible solution for sqlite "only single writer
is allowed at the same time" and database lock.
sqlite has WAL mode for better concurrency and this could maybe be used
to extend the number of writters:
Do you think it would be possible to create a
MyDb.WAL001...MyDb.WAL.002...MyDb.WAL.nnn when a write operation is
currently running in order to allow more writers?
The sqlite engine would then take care of dealing with all the WAL files
when reading data, backup...etc
The maximum of allowed writers could be set by a pragma or another mean
(when opening the db)
It seems a simply way to boost sqlite concurrency.
Am I wrong on this point ?
Best Regards
Luc
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users