For our application, we are facing on several screens performance issues since we are in production and the set of data is growing.
- For a table we moved some big fields containing json content already to a separate table, and made them visible in a form tab. But when click on the form tab, it still will take > 30 sec before it is loaded. It looks like the full table is loading before the related record is shown.
- For a screen we have defined a form layout to show (summary) details of related child records. This is currently build in a view, but when loading that tab it will take some time before the (filtered) data is shown.
- For a table we are showing lot of extra data with expression fields as the base data is not stored in that table, but in related tables. It is not preferred to have that data stored twice, als in the ‘header’ table to reduce the number of expression fields.
Are there suggestions to improve the performance for loading the data in a form detail?