FINDSET/Loop or New Dataitem?

poppins

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

Juhl

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.

aceX

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