FINDSET/Loop or New Dataitem?

poppinspoppins Posts: 634Member
Hi everyone,

In a report, from a performance point of view: is it better to create a local variable in a dataitem, apply filters and loop through it to get certain values, or create a separate dataitem to collect these values?

Thanks in advance :smile:

Answers

  • JuhlJuhl Posts: 259Member
    The same I would say.
    If no fields is added to the dateitem, nothing gets to the dataset so it should be equal.

    Do a test with sql profiler.
    Follow me on my blog juhl.blog
  • aceXaceX Posts: 122Member
    If the values you want to get are sum which need to be calculated, the best way is to use query as an object if you want to get the best performance. If it's another value ... it's pretty much the same
Sign In or Register to comment.