DataItemTableView vs. SETFILTER

shanson@ceservices.com Member Posts: 2

2008-02-11 edited 2008-02-12 in Navision Attain

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.

0

Comments

• 

  tinoruijs Member Posts: 1,226

  2008-02-11

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

  ---

  Tino Ruijs
  Microsoft Dynamics NAV specialist

  0
• 

  tinoruijs Member Posts: 1,226

  2008-02-11

  Did a little test. Saw no difference in performance.
  
  By the way:
  http://www.mibuso.com/forum/viewtopic.php?t=2951&highlight=dataitemtableview+setfilter
  

  ---

  Tino Ruijs
  Microsoft Dynamics NAV specialist

  0
• 

  kine Member Posts: 12,562

  2008-02-12

  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<

  Kamil Sacek
  MVP - Dynamics NAV
  My BLOG
  NAVERTICA a.s.

  0
• 

  tinoruijs Member Posts: 1,226

  2008-02-12

  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.

  ---

  Tino Ruijs
  Microsoft Dynamics NAV specialist

  0