Performance of Entity Backed Record

If i have more than 100k rows in a table and i want to display it in the Record. As it is a huge data how can i handle it to maintain the performance of the record.

  Discussion posts and replies are publicly visible

Parents Reply
  • Hi Mekail,

    you can handle the data at the data base level also while creating the view ( Select Top 1000 Rows) and fetch last modified 1000 rows while fetching the data itself.

    And by using those 2 default filters ( based upon user and date (today()-365)) we can filter the data to maximum level even then if you have too much data add filters based upon requirement so that optimize the data to increase performance.

    I hope this will help you.

    Thanks
Children
No Data