Loops - Performance

[bloggerman]

Do loops in FM cause performance issues?

[blom0344]

Possibly, but the main issues with loops is that it involves a set of joins that often results in returning just a subset of data expected. Performance may also suffer with very large tables in volved

[bvk.cognoise]

Loop is closed path in reportnet it called as ambiguous relationship. That means a query subject contains multiple paths to retrieve the data. It is an exception to resolve to create a shortcut on that query subject otherwise it displays wrong results in reports and performance is degrades


thanks

bvk

[bloggerman]

Thanks. Still wonder how it would effect performance.

[cognostechie]

because it may involve more joins than required and also the way those joins get involved with each other and the resulting SQL written.

[cogcurious]

When we say there are alternate paths between two query subjects, the source and the targets have to be two facts or two dimensions or can be any two query subjects