appsmithorg / appsmithorg/appsmith
[Feature]: Need a connection pool for querying H2
Open
Backend
Enhancement
Integrations Product
Query & JS Pod
Query performance
Query Widgets & IDE Pod
- Dominant language
- TypeScript
- Stars
- 40.9k
- Forks
- 4.8k
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 45
Description
### Is there an existing issue for this?
- [X] I have searched the existing issues
### Summary
- Currently, we used H2 in memory database as a temporary data store and we perform our `where`, `pagination`, `sort`, and `projection` queries on top of it. The plugin opens a new connection with every action invocation. This can saturate the permissible connection limits very soon. Hence, it may be useful to use a connection pool instead.
### Why should this be worked on?
To avoid failure of features like `where`, `sort` etc that are provided as part of UQI experience.
Contributor guide
Assessment
This issue has not been assessed yet.