Hi, we currently switched from a simple file back-end to SQLite in our application (no threads, single process) and use the following settings:
sqlite3_config(SQLITE_CONFIG_SINGLETHREAD) sqlite3_enable_shared_cache(0) PRAGMA synchronous = OFF PRAGMA journal_mode = TRUNCATE It is quite common that the systems we use run out of file descriptors. This is perfectly fine¹ and we could deal with this. With SQLite we have the issue that it constantly re-opens the journal file instead of keeping the file descriptor. Of course, when there are no file descriptors left it can't open the journal file and fails. Is there an option we missed? We're not sure how to fix this without implementing a VFS. Kind regards, Frank ¹ just take it for granted, needs not to be fixed _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
