Use SQL connection pooling

If you are using multiple SQL activity nodes to the same database in your process, you should take advantage of JDBC connection pooling. You can change this setting on the Infor ION Grid IPA node property called pfi.pooling.jdbcUsePooledConnections. This grid parameter is set to false by default. Enabling it will keep a database connection open during the execution of a process so that the server does not have to reconnect for every SQL node.