i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue.
SO i reckon that this performance can be overcome by using sql udf or stored procedure.
If so please help me coz i am pondering over this concept
Thanks in advance
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!