Author Topic: Pool of db connections created by the PCS  (Read 19746 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1317
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Pool of db connections created by the PCS
« 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):
"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 ?

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8001
  • Karma: +114/-20
    • View Profile
Re: Pool of db connections created by the PCS
« Reply #1 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