How can we keep DB session connected in trino?

Trino
1

Hi,

When I am running queries in trino, every time trino creates new connection session with database and closes it on query completion.

While creating new session, it takes long time.

Is there any way to to keep same db connection session opened for long time?

Regards,
Mahebub Sayyed

2

This depends on the connector used. JDBC connectors can use connection pooling. Also the overhead for the connections should be minimal.