appsmithorg / appsmithorg/appsmith
[Feature]: Need a connection pool for querying H2
Aperta
Backend
Enhancement
Integrations Product
Query & JS Pod
Query performance
Query Widgets & IDE Pod
- Lingua principale
- TypeScript
- Stelle
- 40.9k
- Fork
- 4.8k
- Merge medio
- 1g 22h
- PR unite (30g)
- 45
Descrizione
### 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.
Guida per i contributori
Apri la guida per i contributori
Valutazione
Questa issue non è ancora stata valutata.