• State Suggested Answer
  • Replies 9 replies
  • Answers 3 answers
  • Subscribers 11 subscribers
  • Views 5946 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Display Data in Records

krishnaprasadd

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

  Discussion posts and replies are publicly visible

Parents
  • 0
    Appian Employee
    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.
Reply
  • 0
    Appian Employee
    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.
Children
No Data

© 2024 Appian. All rights reserved.