Ctrl K
Sign inStart free
Java · Mid-level · System design

Once a day you need to import a CSV with several million rows into the database through an existing JPA layer. How would you design the import so it doesn't run out of memory and finishes in time?

~10 min by voice

How to approach it

This checks whether the candidate understands how JPA/Hibernate behaves at large volumes: memory (the persistence context, loading the file), speed (JDBC batching, ID generation, bypassing the ORM) and reliability (batches, bad data, restarting after a failure).

Have you seen this question in a real interview?
Answers0
Avg. score—
Strong—
Practiced0
Topics
jpabatch processing
Similar questionsYou notice that the order list page runs hundreds of SQL queries. What could be causing it on the JPA side, and how would you fix it? Mid-levelWhat is the N+1 problem in Hibernate, how do you detect it, and what ways do you have of solving it? What are the trade-offs of each approach? SeniorOnce a day you need to process tens of millions of rows from the database and recompute data based on them, in Java with Spring and JPA. How would you design that processing? Senior

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Sign in to answer

Best with headphones · ~10 min