how many level we can do dot walking in Glide Record query

[as00929632]

I am doing Glide Record query to sc_category table to find the top most parent category name.

I wanted to know to how many level we can do the dot walking in the same table without having any performance issue.

[Ankur Bawiskar]

@as00929632 

no such limitations but yes if you dot walk more then it will have performance impact.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Nilesh Pol]

@as00929632 

As OOTB, recommended to limit your dot walking to a maximum of 3 levels for optimal performance and to avoid impacting the system's responsiveness.

But we can dotwalk as many level you want to achieve your requirement on single record, when its come to multipe records then it might impact on the performance

[Gaurav Rathaur]

Hi @as00929632 ,

It's recommended to limit dot-walking to 3-4 levels within the same table to avoid performance issues; for deeper queries, use GlideRecord instead.

If my response was helpful, please mark it as the correct answer and close the thread. This will help others who come across the same issue.

Thanks!
Gaurav Rathaur

[PrashantLearnIT]

Hi @as00929632 

You can do it as much as you can do any number of times as dot-walking, but as number dot walk increase, you will increase your performance issue.