cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pascal Robert <prob...@druide.com>
Subject Best method to fetch a lot of objects
Date Fri, 19 May 2017 13:27:32 GMT
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?
Mime
View raw message