What happens when we enable connection pooling for a database connection ?
How are the database connections managed? Will each connectors be using the connections from the common pool?Database connections are managed depending on whether or not you are using the Connection Pool tab in the Connection component. Are you planning to use the Database Connection Pooling tab on the Database Connection component? If not, a new connection will be established for each connector. If you are using that tab, then the connection will attempt to grab a connection from the database connection pool per the configuration settings in that tab.
How are the database connections managed? Will each connectors be using the connections from the common pool?
This quote is pulled from https://community.boomi.com/docs/DOC-1141#jive_content_id_Why_isnt_my_Database_connection_pooling_working_as_expected
Some more information can be found here Database connection but none if it directly answered your question.
So coming to the Enable Pooling in the Data base connection it will increase the performance by using resources more efficiently.
please find the attached link to see the more information about the connection pooling
Retrieving data ...