> If you want to have more than one connection to the database from within
> the same process (but not multiple processes) and still use WAL without
> shared-memory, using VFS "unix-excl" instead of the default might work.

With the default VFS for QNX - "unix" the WAL did not worked, using
"unix-excl" worked fine. All the connections are used within the same
process (one connection per thread), the data structures used to
synchronize the readers/writers will be placed in heap, instead of
shared-memory. It should be better also for performance. Of course the
database file will be locked, and cannot be used by other process.

Maybe the WAL documentation should be extended with a note for QNX.

Regards,
Sandu
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to