I have multiple parameterized SP for our Application.
When I Executes those SP individual it will returns output within 1 Sec. But when we are running Test Load with multiple user around 100 or 200 users same time , Same SP Response Time is Over 3-4 Sec.
If i Execute same SP with same Parameter Individual response time is less then 1 Sec.
Posting graphical code sucks because we can't copy any of the code to tell you what might be a problem.
Also, what's with all the trailing underscores? This isn't VB code. Well, not unless you're using VB code to generate the stored procedure.
I'll also tell you that I'd never let this code fly through a peer review because of the hardcoded years that you're going to have to change every year.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)