Page History

...

Save the edits and restart the Servoy Application Server to let the configuration changes take effect.

Tuning of foundset loading

When Servoy loads a foundset, first the PKs are retrieved from the database.
This happens in chunks, when the foundset is loaded the first chunk is retrieved, next chunks are retrieved when needed.
When record data is retrieved from the database, this is also done in chunks.

There are 3 parameters that can be set in the servoy.properties file to control the size of these chunks:

• servoy.foundset.pkChunkSize (default 200) the chunk size for loading PKs in a foundset
• servoy.foundset.chunkSize (default 30) the number of records thar are read when record data is retrieved
• servoy.foundset.initialRelatedChunkSize (default 2*servoy.foundset.chunkSize) for a related foundset, the initial query loads PKs+record data in 1 query with this size.

Servoy Application Server log

...