Jesus wrote:

> Hello, the problem raises with SP of 20 lines or 20000 lines. The one of 20 lines also takes more than 10 seconds to compile. I can't understand that the compilation of triggers are quick and of SP are slow, but i have tested it with different machines and different SP and triggers sizes.

Well, one big difference is that SP's can have input and output columns (they can even spit out multiple rows), which is impossible for triggers.

If I were you I'd write a paramless SP and see if it shows the same dramatic performance drop between 2.1 and 2.5 as your existing SP's.
Then add a trigger with the same code, and see what happens there.
Depending on the outcome, you could give the SP some dummy input parameters and see if that changes anything.
After that, some output parameters.
After that, include a SUSPEND statement to make it a selectable SP.
Etc.

Of course what you experience is disastrous and worth entering into the tracker. But it would help a lot if you could give some example code (as short and simple as possible) that suffers from this problem.


Good luck!
Paul Vinkenoog