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........