Page History
...
Databases have a max connection poolsize to prevent memory problems, but the default 10 can be too low when using many clients on 1 server.
As rule of thumb, if the active connection is > 70% of the max then set the max higher, its however not advised to have more then 30 connection max. (since databases them self have limits on how much they can handle, postgress for example default 40 max)
The idle connection parameter is just for efficient memory usage, when allow many idle more memory is ocupied occupied when idle, low idle means more conenctions connections have to be created (which is expensive time wise)
| Note |
|---|
When noticing proformance performance problems also watch the "performance data" section. At all times the normal Servoy SQL should be below 0.5 seconds not including reporting or search queries. If this is not the case contact an database administrator for index creation. |
Servoy Application Server log
At all times try to keep the Server log free from application errors, all application exceptions point to possible problems inside the application!
Network error are only listed as non critical (orange) which may point to (possible) networks (config) problems, when many errors are continuous listed these should definitely be investigated.
Servoy Application Server settings for Web Client Tuning
...
Overview
Content Tools
Activity