Is frequent opening and closing of the SQLite file expensive operation?
1
vote
1
answer
173
views
I need to build a multi-tenant solution with a requirement for strict data isolation (meaning isolated Databases at tenant level). Even the authentication is different for each tenant?
I find that SQLite with all its compromises to be a right solution. But I understand the maintenance perils of having dedicated instance for each application and the costs it brings. So, I intend to have a multi-tenant single instance solution for the system where all users will use the same instance on the same domain (separated by url-paths). The database connection will be kept in memory for using LRU cache.
That brings me to my question:
- Will this frequent opening of SQLite file cause considerable penalty if load increases moderately? Are there any benchmarks I can refer to?
- Will this corrupt my DB files for any unforeseeable reasons I am not taking into account?
> *Note: My backend will be either Node.js or Elixir/OTP* considering that application is IO bound CPU bound.
Asked by Harshal Patil
(119 rep)
Nov 2, 2023, 10:41 AM
Last activity: Nov 2, 2023, 12:31 PM
Last activity: Nov 2, 2023, 12:31 PM