Name
Type
Constant Integer
Since
2.6.0
Description
The property "SQL Fetch Size" defines the number of rows the system will fetch from the SQL result when building a store. E.g. a fetch size of "100" means, the server loads 100 rows from the database, processes them, then loads the next 100 rows and so on.
If no fetch size is defined, the system will use the default fetch size of the connection or database driver.
We strongly recommend to set this property, because some database servers load by default the complete result set into the memory before it is passed to the client application (in this case instantOLAP). If you work with very large result set (which is not very seldom for stores), this uses a large amount of memory and can cause "Out Of Memory" exceptions in the worst case.
A special case are MySQL server, which only accept "-1" or "0" as a valid for this property. "-1" means to load the result set row by row, "0" will load the complete result set into memory.
Examples
SQL Fetch Size = "100"
SQL Fetch Size = "-1"
Recommended for MySQL databases
