Connection Pooling

Nected establishes a fresh connection with the database server when you initially link the database to your platform. All following queries executed by Nected utilize this connection, ensuring real-time execution of your queries. If the database server closes an idle connection, Nected will initiate a new connection for the subsequent query.

For specific database plugins, including PostgreSQL, MySQL, and Redshift, Nected proactively creates and manages a connection pool. This is because a single connection typically isn't equipped to process multiple queries simultaneously.

It's important to note that the connection pool has a cap of 5 connections. However, having a maximum of 5 connections doesn't imply that only 5 queries can be executed concurrently. In reality, the number of simultaneous queries this pool can handle is significantly greater.