sorry, couldn't go through the whole code ..it's too big for a quick look;

was this initially taking less time , and now you are facing the issue with sp or it's the first run ??