Search criteria impacting the performance

0
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?
asked
1 answers
8

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.

answered