Speeding Up the stored procedure execution..

Question

Hi..!

  I've a tree structure of about more than  2 thousand every day i need to scan for each and every node more than 5 times.. I'm using cursor to count left and right nodes of a node in execution....Its consuming so much time...

Is there any way to speed up the execution of these procedures???

plz help me out .. I'm badly stucked........

Answer 1

a few Questions?
is the client application code open for you to modify, if so i would recommend that on the Init of the WS Object you would put a try catch section and if you go to catch, write the Error Message to log.
about things you need to check, i would try first not to use DNS name but the computer IP, second thing is Firewall clients blocking access to the URL, maybe a proxy on the client...
if you provide some more information i might be able to help you some more