If I have a Business Object, with many relationships, and the use of that Business Object on a given page involves different sets of those relationships depending on input parameters, it is better to just read ALL the relationship data (which may be a lot) every time, or have some initialize logic to interpret the input parameters and read the specific relationships (into separate properties)? Granted lots of potential variables here, looking for a general direction.
In a highly active app, which would be the recommended approach?
The number of relationships is probably not as big a factor as the number of related items that will come back with the query. Database queries are super fast compared to the time to send the resulting payload to the client. My pragmatic approach is usually to do it the easy way until there is a performance issue (usually never) and then adjust course at that time.
