Best method to fetch a lot of objects

[Pascal Robert]

Hi,

I’m still in my FileMaker -> MySQL migration project. This time, I want to 
migrate a FileMaker table who have 445 244 records in it. If I fetch everything 
into an object entity for each row, I’m getting a Java heap space problem, 
which is somewhat expected by the size of the result set.

If I call setFetchLimit() with a 10 000 limit, works fine. FileMaker doesn’t 
support fetch limits, so I can’t do something on that side. 

Any tips?