Forum Discussion
Resolver IFilter by list or by arguments -- very different processing times
Hello PhilippeMuniesa
try to change approach 1 like this
let Source - Ouvre_FEC1, BufferList = List.Buffer(Liste_JX_Selection_Liste), Filtre_Selon_Jx_Selectionnes - Table.SelectRows (Source, each List.Contains (BufferList , [JournalCode]) In Filtre_Selon_Jx_SelectionnesIf this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Community ChampionHello PhilippeMuniesa
try to change approach 1 like this
let
Source - Ouvre_FEC1,
BufferList = List.Buffer(Liste_JX_Selection_Liste),
Filtre_Selon_Jx_Selectionnes - Table.SelectRows (Source, each List.Contains (BufferList , [JournalCode])
In
Filtre_Selon_Jx_Selectionnes
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
- PhilippeMuniesa
Jimmy,
it works perfectly and much faster. I had not yet been able to realize the advantage of list.buffer or table.buffer. here is what is made for List.Buffer.
However, I cannot explain the very big difference in processing time for a list that has only two elements.
2mn, 14sec in the original request
13 sec in the request you propose with List.Buffer ...
Thanks a lot
Philippe
- PhilippeMuniesa
Jimmy,
it works perfectly and much faster. I had not yet been able to realize the advantage of list.buffer or table.buffer. here is what is made for List.Buffer.
However, I cannot explain the very big difference in processing time for a list that has only two elements.
2mn, 14sec in the original request
13 sec in the request you propose with List.Buffer ...
Thanks a lot
Philippe
- Jimmy801
Hello PhilippeMuniesa
List.Buffer is buffering the data and therefore the engine can access much faster. When you don't use List.Buffer the engine has to read the list on every row when filtering.
BR
Jimmy
