Display Data in Records

Question

Hi All, 
 I have a requirement where in which i have fetch data from 7 tables and display that data in record. Is creating a view is the best approach or else please suggest if can handle it in a better way. 
 Thanks in Advance

Shiva Valusa · Answer

Hi krishnaprasadd, 
 
AFAIK View will be good enough to show the data in your Records from the required tables. 
 
Stored procs will be useful when we have multiple calls in database to show the data in UI forms. Also we have to use additionally a plugin to execute stored procedure.

Robert Shankin · Answer

Use of a view is a common practice when preparing data for use with a Record type. 
 
Stored procedures with outputs are typically only explored as a secondary option when a view is not possible. 
Stored procedures often require more work, and a plugin is needed to execute them. 
 
When constructing your view, emphasis on efficiency is important. 
Be sure to use proper joins and avoid use of the IN() operator. 
Indexes on your join columns in the base tables are typically recommended to maximize read performance. Those same indexes can impact write latency, but it's usually not an issue.

Abhay Giri · Answer

Hi, 
 
In my view: 
 
If you have limited number of columns to display in records then view is good option. Just select only those column which need to display in record. 
 
Regards 
Abhay