[h2] setFetchSize with large ResultSet embdded mode

2015-12-02 Thread Adam McMahon
H2 Group, I am trying to understand Statement.setFetchSize with large ResultSets. The documentation says that it this function sets the number of rows suggested to read in one step. What does it mean by "suggested". In what situations is the setFetchSize value not honored? My the situation

Re: [h2] setFetchSize with large ResultSet embdded mode

2015-12-02 Thread Noel Grandin
Our default maximum number of rows in a result set we will load into memory is: = 4 per GB of available RAM If you want it to be less, you can explicitly set it on the command line with -Dh2.maxMemoryRows= -- You received this message because you are subscribed to the Google Groups