190101 - no subject - How to efficiently display data from mul

mjmallet over 9 years ago

How to efficiently display data from multiple tables in a report?

I have to create a report that will be retrieving all rows from 4-5 different tables. The client wants to have the ability to extract that report into excel.

Is it best to create a view on the database that would consolidate all tables and then create a data type/data store to get that information to display in my grid?

I want to limit the number of queries to the database. If I fetch the data from each tables in SAIL and store it to a local variable, and then query against those local variable.

Which options would be less effort? And what would be the best practice in this scenario?

Discussion posts and replies are publicly visible

Parents

0 narasimhaadityac
A Score Level 2
over 9 years ago

Hi mjmallet, it depends on the total data volume you are looking at and the relationship between those tables. If your requirement has any dependency on selection of tables.. then it would be good to go for individual if not then a view on top of the query would be a better solution with the queryEntity.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 narasimhaadityac
A Score Level 2
over 9 years ago

Hi mjmallet, it depends on the total data volume you are looking at and the relationship between those tables. If your requirement has any dependency on selection of tables.. then it would be good to go for individual if not then a view on top of the query would be a better solution with the queryEntity.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data