> PRAGMA query_only = YES This might just be a workable solution for us.
>A SELECT statement should never cause the WAL file to grow. Hmmmm...This is comforting and means I need to take a step back, review, reproduce and verify. If I continue to believe otherwise I'll respond with a code example. >It might create a *-shm file. If that is the problem, and you only ever have a >single connection to the database open, you could try executing "PRAGMA >locking_mode = exclusive" Only the wal file grows. The -shm file remains the same size. As much as I would like to have the -shm file in ram this is not possible due to far too many simultaneous connections. Thanks again. Brett. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
