Hello, the database has a root file. The subfiles are all loaded via separate connections as far as I know.
Another idea of mine: If I know the database will be only written to very rarely, can I prevent sqlite from using the WAL files at all in the meantime? > Am 19.09.2018 um 21:36 schrieb Simon Slavin <[email protected]>: > > On 19 Sep 2018, at 7:49pm, Roger Cuypers <[email protected]> wrote: > >> As far as I know it uses journaling with WAL and has a lot of files/tables >> (about 400). > > Excuse the low-end questions, but they might help save us a lot of silly > suggestions. > > Does SQLite have lots of these open at one time ? If so, does it do it by > opening a main database and attaching lots of these to it, or by opening each > hone on a separate connection ? > > If they're all attached to a single connection, can you open each one on a > separate connection instead ? > > Are you aware that you can put more than one table in a database file ? > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
