Set webserver pool size

You can specify the pool size of your webservers. For optimal performance, it’s possible to set a different size for each webserver.

What is the pool size?

The system creates a connection pool for each connection string. The minimum pool size determines how many connection objects must be added to the pool. The maximum pool size determines the maximum number of connections that are added to the pool.

Note

If the master.config is not located in the default folder, the webservice folder must contain a user.config file, which indicates where the master.config file is located.

Specify the pool size

To specify the pool size, perform the following steps:

1. Navigate to the master.config file.

2. Locate the entry of the webserver that you want to edit.

3. Change the Max Pool Size to the required value. For example: 500.

4. Change the Min Pool Size to the required value. For example: 300.

5. Save your changes and close the file.

<appSettings type="IS.CMS">
    <add key="LogSubDir" value="log\IS.CMS" />
  </appSettings>
<appSettings type="IS.P01">
    <add key="DB:default" value="Server=GF-VM-D01;Database=Grassfish_Base;Persist Security Info=False;Integrated Security=SSPI;Encrypt=True;TrustServerCertificate=True;Max Pool Size=500;Min Pool Size=300"/>
    <add key="LogSubDir" value="log\IS.PL01" />
    <add key="MaxLogLevel_File" value="2"/>
  </appSettings>
<appSettings type="IS.P02">
    <add key="DB:default" value="Server=GF-VM-D02;Database=Grassfish_Base;Persist Security Info=False;Integrated Security=SSPI;Encrypt=True;TrustServerCertificate=True;Max Pool Size=500;Min Pool Size=300"/>
    <add key="LogSubDir" value="log\IS.PL02" />
    <add key="MaxLogLevel_File" value="2"/>
  </appSettings>

Specify the master.config file path

To specify the path to the master.config file, perform the following steps:

1. Create a user.config file.

2. Put the following lines of code in the file:

   <appSettings>
    <add key="MasterConfigType" value="IS.CMS" />
     <add key="MasterConfigDir" value="\\gf-vm-f01\GVServer2\master.config"/>
   </appSettings>

3. Set the value of MasterConfigType to the type of the server. It must be the same as in the master.config file.

4. Set the value of MasterConfigDir to the path of the master.config file.

5. Save your changes and close the file.

6. Go to the directory www\gv2\webservices\ on your server and store the file in the folder of the webserver.