Hi Michael,
Thanks for the reply, generally we only have 2 separate related properties tables at most on a single job template.
As for how many properties are there in the table, it varies but can get quiet large (a few 1000). however only a handful of these would be related to a single job (1-4 normally).
The data types are normally integers and maybe some strings.
Anecdotally, we have noticed that a lot of related records against a single job, say more than 20, will have a significant increase in the time taken to retrieve the records when compared to say 2 records, however this increase seems normal/expected to us.
Our main concern is the difference between the standalone desktop Workflow Manager application and ArcGIS Pro, with the standalone app showing almost instant retrieval and the same records in Pro always slower to retrieve. We have tested this on multiple separate deployments and have experienced the same results. If you believe this should not be the case and the same performance should be expected between ArcGIS Pro and the standalone app than I will submit a support case to chase this up.