BAMQuery.fetchSize

Int

When a sql sentence is executed not all the records are retrieved, it depends on the fetchSize value. The memory of the server running the sql query, may collapse if the quantity of affected records is too big. That is why a "cursor" is created in the server and it only retrieves "n" records per time. The number "n" should be a balance between the memory usage and performance. If "n = 0", the fetch retrieves all the records at once and there is only one access. If "n = 1", it will access the records one by one. This is, probably, the worst value to set to the "fetchSize". So, if you had "R" records that the sql query will retrieve, the quantity of times that will access the server is: "R/n", with "n > 0". Default value: 0