Improvement query and Implementation of multithreading in Java

Improvement query

• Query using inner join instead of loop each header to get detail

• Use ORM benefit to make a clean object of entity collections.

• Provide parameter using IN clause instead of do each

Implementation of multithreading

• Can be implement when convert entity to DTO (Data Transfer Object)

• Must

• Must not 

• Implement good logging

• Thread safe

• Blocking

• Monitoring with VisualVM and Stress test with jMeter