BPCheckNestedLoopinCode : Nested data access loop found in method

(1) Share

Report

Posted on by Community member

Hi guys,

I have this warning: Nested data access loop found in X method for this part (attached bellow), and I am not really sure how to get rid of it. Also I couldn't have find anything useful.

Could you please help me with that?

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Martin Dráb 237,959 Most Valuable Professional on at

Like (0)

Report

It warns your about a performance problem. Let's say your outer query returns five records and the inner one returns ten for each localX.xId. Then you'll run 5*10 more queries than necessary. This can easily cause a huge problem.

The fix of this bug is simple - use a join to fetch both table at once in a single query.

Was this reply helpful? Yes No
Suggested answer

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report
Hi User,

As Martin said you need to replace the 2 whiles with a join -- for better performance
while select firstonly xId from localX order by y desc where localX.ItemId == table.Iteml join local where local.xId == localX.xId { }

Thanks,
Layan Jweihan

Was this reply helpful? Yes No
Martin Dráb 237,959 Most Valuable Professional on at

Like (0)

Report
Only now I've noticed that the first loop uses firstOnly keyword, therefore there doesn't have to a be any loop at all. You can do something like this:
select firstonly xId from localX order by y desc where localX.ItemId == table.ItemId; if (localX.xId) { while select local where local.xId == localX.xId; { } }

Was this reply helpful? Yes No

Join the conversation

Community site session details

BPCheckNestedLoopinCode : Nested data access loop found in method

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

BPCheckNestedLoopinCode : Nested data access loop found in method

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates