Slow Filtering

(0) Share

Report

Posted on by AlGom

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"
)
);;

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AlGom ,

Sorting on entire table would cost much time and unnecessary. Please try and sort on the filtered table:

Set( FilteredDataa; SortByColumns(Filter(Matrix_MovProducto cr512_cod_zona = "REP"; cr512_cod_ubicacion = "REP" );"cr512_cod_ubicacion";SortOrder.Descending) );;

Best regards,

Was this reply helpful? Yes No
Yogesh Murugan 447 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this code:
Set( FilteredDataa, SortByColumns( Filter( Matrix_MovProducto, cr512_cod_zona = "REP" && cr512_cod_ubicacion = "REP" ),"cr512_cod_ubicacion",SortOrder.Descending ));

Was this reply helpful? Yes No
AlGom 18 on at

Like (0)

Report
Copy link

Link copied!

Same time, aprox 10 seconds. How ever, what's the point of sorting after filtering?. Is not more usefull, talking about performance, sorting the table before the filter to make something like an index ( like SQL does )?.

Was this reply helpful? Yes No