Hi all,
I have now successfully installed Servoy on a $250/year account on a shared Linux server. We are using PostgreSQL 8.1 as backend database.
Everything is working fine,…
…unless we connect using client, developer and run the web server (which also talks to the database) at once.
The problem is that we run out of database connections, the ‘official’ limit is 10 per account to preserve resources on the shared server. I have temporarily increased connections to 20, but the hosting company would like to us reduce this back closer to 10.
This is really ironic since PostgreSQL will do unlimited connections for FREE!
When setting up a database connections in Servoy, there are two options:
- Maximum Number of Connections (Defaults to 10)
- Maximum Number of Idle Connections (Defaults to 5)
Do these apply per database, or, per server (IP)?
And how low can we set them without crippling Servoy? 5/2, 3/1, 1/0…
Have checked the documentation in the Server manual for this but there is little information other than that the settings exist.