Sample Header Ad - 728x90

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