3 ms·
What problems regarding resource usage can come up when trying to use thousands of sqlite databases simultaneously from a single process?
by Scarbutt 4y ago
What problems regarding resource usage can come up when trying to use thousands of sqlite databases simultaneously from a single process?
- benbjohnson 4y agoYou'll probably hit file descriptor limits so you'll need to up those. There's also some memory overhead per connection. I'd recommend limiting the number of concurrent connections on a server if you're running on a resource constrained box. In practice, you probably won't have all thousand databases querying at the same time and reopening SQLite connections is pretty fast.