DataItemTableView vs. SETFILTER

shanson@ceservices.com

Could someone tell me which is quicker when selecting records from a table:

a. DataItemTableView=SORTING(Job No.) WHERE (Type=CONST(Usage));

OR

b. SETFILTER(Type,'Usage')

Thank you.

tinoruijs

I think it doesn't matter.
Let's test it.

tinoruijs

Did a little test. Saw no difference in performance.

By the way:
http://www.mibuso.com/forum/viewtopic.php?t=2951&highlight=dataitemtableview+setfilter

kine

And may be it will be better to use

b.SETRANGE(Type,b.Type::"Usage");

Please, do not use filtering to string when field is type Option... [-o<

tinoruijs

kine wrote:

And may be it will be better to use

b.SETRANGE(Type,b.Type::"Usage");

Please, do not use filtering to string when field is type Option... [-o<

That's right. For my little test I used SETRANGE.