Hello all, i'm facing some slow process in my app when dataverse tables starts to be a bit bigger ( 7k+ lines).
My question is:
why this kind of filtering spends 10+ seconds for asign the values to the FilteredDataa var.? I also did it with the clearCollect funcition, but the time was the same. In this example the filter gets 200 lines aprox.
I can't find any way to do a Index filtering type in dataverse except the sortByColumns function that i'm already using.
So anyone can tell me why is this slow and a way to improve the performance?.
Set(
FilteredDataa;
Filter(SortByColumns(Matrix_MovProducto;"cr512_cod_ubicacion";SortOrder.Descending);
cr512_cod_zona = "REP";
cr512_cod_ubicacion = "REP"
)
);;