Chapter 30. V9.08
30.9. Speedup slow database connection - Increase number of datasets to cached
Prev  Next

30.9. Speedup slow database connection - Increase number of datasets to cached

Some databases only cache 10 datasets at fetches. This causes that database requests with a lot of datasets are very slow at connections with high latency. Via setFetchSize the number of datasets to be cached can be increased.

$CADENAS_SETUP/jdbc.cfg -> Block <database name>

Example:

[PLINKDB_ORACLE] 
DriverClass=oracle.jdbc.driver.OracleDriver 
URL=jdbc:oracle:thin:@10.10.12.96:1521:xe 
Settings=FetchSize=1000

Prev Up Next
30.8. Reports with additional filters Variables search | Topology search | Preferred rows  Home 30.10. Syntax/behavior harmonized between CreationOptions and AttributeMapping