> 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