SQLite Forum

Connection Pool always empty?
Login
Alright so it seems to work, but you need to know how:

- As mentioned [here](https://system.data.sqlite.org/index.html/tktview/69cfdf79fa11f506602146b0fd192c9a546ad167) you need to use Default mode for opening the file. Read-Only or fail if missing would deny a pool entry.
- The pool entries are purged when the last connection is closed. Not quite what I expected. In my assumption the pool would be alive per process, so that even when dropping to 0 open conenctions I have still a few in the pool. THats not the case.

So in order to achieve what I need I have to open a dummy connection and keep it open. Okay, not very beautiful, but it works.

BR Florian