Should I use two query entities ?
Discussion posts and replies are publicly visible
Hi ,
If you have two or more different table with no dependency or relationship among them like Student(StudentID,StudentName,..), Qualifications(QualificationID, QualificationName,...), etc., you can use two different query entities to get the details.
If you have two or more different table with dependency or relationship among them like foreign key, you can create a view, create cdt for view then using query entities get the details. This will reduce the load on the interface when there are huge records. When it takes more time to load the data, screen will be showing working or it makes some delay in displaying the results. So we can avoid performance and user experience issue.