Database Connector - Is it possible to connect a single time and cache it for the rest of the queries?
2
In our application we noticed that everytime we execute an SQL statement mendix creates a new connection to the database, then closes it at the end. This affects performance a bit because of the time it takes to connect then make the query. Is there a way to keep this connection cached somehow and just execute the queries directly to increase performance? We use an external database (PostgreSQL) Think about the scenario of multiple database SELECTS in a single microflow that is executed in an REST API request, mendix opens and closes the connection for each one, making it a bit slow