Using findIterate with MySQL streams the entire result set at once about ebean HOT 7 CLOSED

I have pushed up a fix. On the DatabasePlatform there is a forwardOnlyHintOnFindIterate. This is set to true on the MySqlPlatform. For creating PreparedStatements for findIterate() and findVisit() this databasePlatform hint is checked and if set creates the statement with the appropriate hints.

So out of the box this fix is specific to MySql and findIterate() or findVisit().

If you can pull/build and confirm this fixes your specific case that would be great.

from ebean.

Thanks, I'll give it a shot this week and let you know how it goes.

from ebean.

Sorry for the delay. This seems to be working well now.

I tested this in my play application, first without it there, and then with it there. Without it, the memory after using findIterate, but before iterating through the values, had sharply risen.

Updating to use 3.2.5, the memory didn't start going down until after iterating through the list provided by findIterate.

from ebean.

Right so I'll close this issue as fixed then.

from ebean.

I apologize, but I think it may still be gathering the entire resultset in memory. Using a debugger on the code, it seems that the fetchSize is getting set to 0, instead of Integer.MIN_VALUE. I think the fetchSize getting set is important to indicate to the driver that the results should be streamed.

from ebean.

Yes, I have reproduced this and it is not fixed without

pstmt.setFetchSize(Integer.MIN_VALUE);

from ebean.

Fixed in 4.0.1

from ebean.