Skip to main content

Forentity or While?

  • June 9, 2023
  • 3 replies
  • 0 views
E

Hello.

which best performance for traversing large volumes of data?

ForEntity

;my code

Endfor

or

While

;my code

endwhile



------------------------------
Edson Gomems
Analyst
Coamo -Coop. Agropecuaria Mouraoense
------------------------------

    E

    3 replies

    Juliano Anoar Haoach Garcia
    Forum|alt.badge.img

    Hello.

    which best performance for traversing large volumes of data?

    ForEntity

    ;my code

    Endfor

    or

    While

    ;my code

    endwhile



    ------------------------------
    Edson Gomems
    Analyst
    Coamo -Coop. Agropecuaria Mouraoense
    ------------------------------

    Morning,

    Particularly I prefer the while. Forentity is a little more performant (almost imperceptible). The while gives us more control, especially when using discard for loops with large amounts of data.



    ------------------------------
    Juliano Anoar Haoach Garcia
    Suport Analyst
    Coamo -Coop. Agropecuaria Mouraoense
    Campo Mourão BR
    ------------------------------
    E
    dino seelig
    Forum|alt.badge.img
    • dino seelig
    • Participating Frequently
    • June 14, 2023

    Hello.

    which best performance for traversing large volumes of data?

    ForEntity

    ;my code

    Endfor

    or

    While

    ;my code

    endwhile



    ------------------------------
    Edson Gomems
    Analyst
    Coamo -Coop. Agropecuaria Mouraoense
    ------------------------------

    Hmm it depends, saving memory  i will use a discard loop. A for Entity does not fit in that case, While a while loop fits. For the rest incase it's just a loop for walking occurrences  use forEntity.



    ------------------------------
    Dino Seelig
    CTO
    Tcco
    Drunen NL
    ------------------------------
    E
    Michael Taylor

    Hello.

    which best performance for traversing large volumes of data?

    ForEntity

    ;my code

    Endfor

    or

    While

    ;my code

    endwhile



    ------------------------------
    Edson Gomems
    Analyst
    Coamo -Coop. Agropecuaria Mouraoense
    ------------------------------

    forentity doesn't generate a procerror when they get to the end of the list, so is the simplest to use with exceptions.

    Kind regards,

    Mike



    ------------------------------
    Michael Taylor
    Rocket Internal - All Brands
    ------------------------------

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement