What is connection pooling in SAP EP - Enterprise Portal?

SAP Term: connection pooling

• Component: EP

• Component Name: Enterprise Portal

• Description: Connection pooling enables an application to use a connection from a pool of connections that do not need to be reestablished for each use. Once a connection has been created and placed in a pool, an application can reuse that connection without performing the complete connection process. This can result in significant performance gains, because applications can save the overhead involved in making a connection. This can be particularly significant for middle-tier applications that connect over a network or for applications that repeatedly connect and disconnect, such as Internet applications. In addition to performance gains, the connection pooling architecture enables an environment and its associated connections to be used by multiple components in a single process. This means that stand-alone components in the same process can interact without being aware of each other. A connection in a connection pool can be used repeatedly by multiple components. Source: MSDN Online Library

Smart SAP Assistant

• Key Concepts: 
  Connection pooling is a feature of the SAP Enterprise Portal (EP) that allows multiple users to access the same connection to a database. This reduces the amount of resources needed to establish and maintain connections, resulting in improved performance and scalability. 
  
  How to use it: 
  Connection pooling is enabled by default in the EP. To configure it, you can use the Visual Administrator tool or the EP Configuration Wizard. You can also set up connection pooling for specific applications or services. 
  
  Tips & Tricks: 
  When configuring connection pooling, it is important to consider the number of users that will be accessing the database and the type of data that will be accessed. This will help ensure that the connection pool is optimized for performance and scalability. 
  
  Related Information: 
  For more information on connection pooling in SAP EP, please refer to the official SAP documentation. Additionally, there are many online resources available that provide tips and best practices for configuring connection pooling in SAP EP.