April 2, 2007 at 10:39 pm
Hi,
Our program use to calling maybe 10+ SP to insert/update/delete
data. All the call to SP seem to be slow.
However, when we change all the call of SP (concatenate all the SP together)into direct calling
by the program, the speed is impressive.
For example,
a)Overall speed is very slow
Program call - SP1 (delete)
call - SP2 (insert
call - SP3 (update)
b)Overall Speed is very fast, similar to above method
If we concatenate all the 03 SP code into
direct call by the program, instead of calling individual
SP,the speed is impressive.
Hence, is there any way to achieve the same speed using SP ?
Thank you
April 3, 2007 at 8:30 am
Can you give an idea of what's fast and what's slow in terms of time? If you make 3 direct calls it should be fairly close in time to all the code being in one proc. That's if the plan is compiled for the proc. If you are closing and opening connections between calls it could be slower.
Are these complicated procedures? Can you post any code if it's not too long.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply