Content
When reviewing the execution trace of a query, depending on the data source, you will see one of the properties listed is called “Cached connection”. This property is not related to data caching.
The property "Cached connection" in the execution trace indicates that the JDBC/ODBC connection used to retrieve data from a data source is a reused connection from a previous query execution. By default, the JDBC and ODBC data sources use a pool of connections to avoid opening new connections on each request.
The first time Denodo queries a data source it has to establish a connection with the database, the database has to authenticate the client and allocate the memory for the new connection.
When the connection is already created, the aforementioned procedure will be avoided. As shown in the screenshot below, the data source reuses an existing connection.
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Questions
