Search criteria impacting the performance

Hello all,  I have a very complex logic to show a tree of data which contain 7 listviews, and there’s a non-persistent parent entity for the page, I added the SearchText attribute to the parent entity to search for the categories, meanwhile I have to loop on all of the children on each DS microflow,  noting that I have a huge amount of data (around 30K and might reach more) is it preferable to keep the same logic im using for the search or should I create a new non-persistent entity, add association with each level and then set associations with each level we have and then on the DS microflow get the associations we fill when we search?
1 answers

Hi Khalil,

Both methods will have the same impact on the performance. But second method will have impact on the memory usage also. So, I am suggesting the existing method.