On 19 Sep 2018, at 7:49pm, Roger Cuypers <rcuyp...@arcor.de> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users