How to improve the performance of Master Detail Relationship
Creating a master details relation ship between two data containers is similar to creating join between two tables. when you create Master detail relation each row from parent query is compared with each record in child query. Hence the performance will be degraded.
How to improve the performance without loosing the functionality:
1. You need to create a filter in the child query. For example if you are linking Product line in Master and child queries. You need to create a ?ProductLine? Prompt in Child query
2. Now change the link between Product Line to Product Line parameter in child query like shown below.
With this approach we are filtering the child query without comparing record to record. Hence the performance will improve drastically.
No comments:
Post a Comment