Query Entity data retrieval ?

Hi,

It dependents on the volume of data, ex you querying a table which have only 3 columns vs 50 columns. When querying tables we need to follow certain best practices

• Query only the data that you need using query selection
  • ex: If table have 50 columns if you only need to show 10 columns only query those 10 columns not the entire table
• Don't query all the data when you load the page (If your planning to display that data in read only grid)
  • Use paging info to query the data in batches 
• Also, create indexes in your table most frequent columns that you query (As part of normalization) 

Hi,

It dependents on the volume of data, ex you querying a table which have only 3 columns vs 50 columns. When querying tables we need to follow certain best practices

• Query only the data that you need using query selection
  • ex: If table have 50 columns if you only need to show 10 columns only query those 10 columns not the entire table
• Don't query all the data when you load the page (If your planning to display that data in read only grid)
  • Use paging info to query the data in batches 
• Also, create indexes in your table most frequent columns that you query (As part of normalization)