appsmithorg / appsmithorg/appsmith
[Feature]: Need a connection pool for querying H2
Abierto
Backend
Enhancement
Integrations Product
Query & JS Pod
Query performance
Query Widgets & IDE Pod
- Lenguaje dominante
- TypeScript
- Estrellas
- 40.9k
- Forks
- 4.8k
- Merge medio
- 1 d 22 h
- PR fusionados (30 d)
- 45
Descripción
### 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.
Guía de contribución
Evaluación
Este issue todavía no se ha evaluado.