Skip to main content

Customizing Data APIs usage

You can edit some configuration parameters to refine the volume of data that can be exchanged between the Remote Engine Gen2 and the database you created a Managing Data APIs on, depending on your usage.

Parameters configurable in default/.env file in the Remote Engine Gen2 installation directory
Parameter Description
DATASET_API_NUMBER_CONNECTIONS_PER_DATABASE This parameter allows you to control the number of permanent connections opened by the Remote Engine Gen2 with a database.

More connections means that you can handle more requests in parallel, but in return, the database can also protect itself by setting a maximum number of parallel connections, regardless of the origin.

The default value is 5.

DATASET_API_JDBC_FETCH_SIZE This parameter allows you to control the number of records coming from the database, that the Remote Engine Gen2 will have to process at a given time.

Setting a low value will reduce the memory footprint of the JVM, but will increase the number of exchanges with the database.

Setting a high value will reduce the number of exchanges with the database.

Setting this value to 0 will disable this feature. With each request to the database, all records are retrieved in one operation.

The default value is 0.

DATASET_API_ODATA_MAX_SERVER_PAGE_SIZE This parameter allows you to control how much records are paginated on the server side and written to the OData client.

OData clients are usually able to automatically consume several consecutive pages.

Setting a low value mean that the server only handles a few records at a time, and consumes less memory.

Setting a high value means that the server will handle a high number of records at a time.

Setting this parameter to 0 means there will be no server side pagination

The default value is 100.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!