Best approach to fetch hundreds of thousands of records
I'm wondering what's the best approach or best practice around fetching hundreds of thousands of records for initial full data loads to transfer somewhere else?
Currently, I'm using jpa + pagination and it is slow. I'm loading around ~400k objects in memory but is the better approach to use jdbctemplate? What if you also need to join a few tables?
What would you recommend here?
Currently, I'm using jpa + pagination and it is slow. I'm loading around ~400k objects in memory but is the better approach to use jdbctemplate? What if you also need to join a few tables?
What would you recommend here?
