Koen Verbeeck (1/26/2015)

---

GilaMonster (1/26/2015)

---

Sean Lange (1/26/2015)

---

Jack Corbett (1/26/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200 parameters and another 200 variables. I copied the sql to a text file and there are 113 while loops. Hope they don't want this done quickly as a complete rewrite is in my near future.

I can almost understand 3700 lines, but 113 loops! Wow. I'm sure you'll be able to get it to run much faster, but I'd need a couple of days just to figure out what it is doing. You don't happen to have access to a spec for the original development.

BWAAHAA!!!! Spec docs???

What's a spec?

I know I've heard people talk about them, can't recall ever seeing one. Must be some mythical thing like a unicorn.

It shares a flat with the documentation. 😀