Page History
| Stoc |
|---|
Java Virtual Machine (JVM) Tuning
Java version
Servoy supports both Java 5 and Java 6 (for the Application Server, the Smart Client and Servoy Developer). As Java 6 has numerous performance improvements, it is preferred over Java 5.
...
In servoy_server.sh/bat:
| Code Block |
|---|
java -server -Djava.awt.headless=true .....
|
...
Memory
Database Connection Pool Tuning
See Connection Pooling in the Database Connections chapter
Database Tuning
Architecture
In order to get the best possible performance, the communication between the Servoy Application Server and the database needs to be as fast as possible. The fastest option would be installing the database engine and the Servoy Application Server on the same machine, whether or not this is possible depends on the dimensions of the physical server and the resource requirements of both the database engine and the Servoy Application Server.
...
Especially for SQL statements that are fired often and take up significant time it should be checked if it's possible to optimize the database, for example by creating the relevant indexes.
Foundset loading Tuning
Servoy loads a foundset by first retrieving the PKs from the database. This retrieval is done in chunks: when the foundset is initialized, the first chunk is retrieved, consecutive chunks are retrieved when needed.
...
Setting | Default Value | Description |
|---|---|---|
servoy.foundset.pkChunkSize | 200 | Chunk size for foundset PK retrieval |
servoy.foundset.chunkSize | 30 | Chunk size for record data retrieval |
servoy.foundset.initialRelatedChunkSize | 2 * servoy.foundset.chunkSize | Chunk size for related record retrieval |
The values can be modified in an attempt to increase performance. The optimal values differ per application, thus no guidelines are available for alternative values. Tuning needs to be done by altering the values and monitoring the performance afterwards. The defaults are set based on averages.
Web Client Tuning
Content compression
In order to minimize the size of the content that the browser has to download for the Web Client, the application server serving the content can compress the content. The Servoy Application Server is configured to automatically compress content.
...
Save the edits and restart the Servoy Application Server to let the configuration changes take effect.
Servoy Application Server log
At all times try to keep the Server log free from javascript application errors/excpetions, all application exceptions point to possible problems inside the application.
...
Overview
Content Tools
Activity