Hi
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
Software/Hardware used:
ASKED:
April 26, 2008 7:38 AM
UPDATED:
April 28, 2008 12:53 PM
Thanks for The reply Mr.Denny.
Well i am using .net platform 2.0 and sql server 2005
i was too getting the same performance issue when i use this in my vb code.
But if i use recursion i am getting the exact answer.
Is there any other possibility to overcome this issue.
Thanks
Regards
Balaji