[CAUSEWAY-3707] [Perf] Preload mixin property values (when displayed in a collection)

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.0.0, 3.0.0
• Fix Version/s: 3.3.0, 2.3.0
• Component/s: Viewer Wicket
• Assignee: Unassigned
• Reporter: Daniel Keir Haywood
• Created: 28/Mar/24 08:48
• Updated: 05/Jul/24 13:58

Description

Following on and similar to CAUSEWAY-3706, if an object has a mixin property, and that property is part of a collection, then we'll get an N+1 style of issue when each object's (row's) property is evaluated.

To load these instead in bulk, we could have a preload hook (an optional interface to be implemented by mixins) that would return a `List<Bookmark>`.  The Wicket viewer would call this for each object resolved and would then aggregate the Bookmarks and fire an event for the JPA/JDO persistence store to load them in bulk.

This wouldn't be an exact science, but ought to reduce database queries to some extent.  It would probably be easier for JPA than JDO because the underlying Ids of the objects that need to be resolved are (probably) easier to obtain.