[FINERACT-912] Tune JPA Eager/Lazy loading for performance

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: scalability
• Assignee: Unassigned
• Reporter: Michael Vorburger
• Created: 26/Apr/20 10:46
• Updated: 09/Nov/21 21:07

Description

as part of the overall FINERACT-867, tuning JPA Eager/Lazy loading for performance is always fun.

FINERACT-902 is worth reading re. this topic. The goal of this issue would be to:

1. measure numbers of SQL queries per API call
2. measure the time of each such query, on "full" (non-demo) real database
3. see if throwing in a few more fetch=FetchType.LAZY annotation at the right place can help
4. use more fine grained per operation Fetch Plans instead annotations, based on measues

Issue Links

• blocks: FINERACT-867 Scalability & Performance Enhancements for Supporting Millions of Clients, High TPS, and Concurrent Users
• is part of: FINERACT-1439 Performance hammered by too many EAGER Load