Sparx Systems Forum

Pro Cloud Server / Prolaborate / WebEA => PCS General Board => Topic started by: Guillaume on March 22, 2024, 01:37:40 am

Title: Pool of db connections created by the PCS
Post by: Guillaume on March 22, 2024, 01:37:40 am

Hi,

I noticed that around 15/20 db connections are created as soon as the first EA users opens an access to a DB via the Pro Cloud Server.
I found the associated explanation from the PCS user guide (https://sparxsystems.com/enterprise_architect_user_guide/16.1/the_model_repository/cloud_server_client_add_sqlsvr.html (https://sparxsystems.com/enterprise_architect_user_guide/16.1/the_model_repository/cloud_server_client_add_sqlsvr.html)):
"the Pro Cloud Server creates a 'pool' of database connections when it starts. Database connections from the pool are allocated to action each request for data as it arrives and, since they have already been established, execution is almost instantaneous."

I suppose the number of db connections is automatically managed by the PCS. Is it the case ? Would it be relevant to manage this number via the PCS configuration ?

Title: Re: Pool of db connections created by the PCS
Post by: Eve on March 22, 2024, 08:28:48 am

Yes, it is automatically managed. They are created transparently as needed and cleaned up if they haven't been used recently.

The number can be managed with the 'Max Simultaneous Queries' option.
https://sparxsystems.com/enterprise_architect_user_guide/16.1/the_model_repository/cloud_server_client_config.html (https://sparxsystems.com/enterprise_architect_user_guide/16.1/the_model_repository/cloud_server_client_config.html)