You are handling with large result sets and need to fetch all results anyway? Remember JPA holds a pointer to your database with each request. So for instance this foreach will go back to the DB every 10...