January 25, 2013 at 12:14 pm
i have attached an image with this thread. my application is using jdbc drives. same operation in oracle is taking 3 secs but in SQL server it is taking 2mins.
I took a profiler trace. seems like after every implicit transaction on/off operation i am losing 3 milli seconds. Does any one know why? and how to fix this?
January 25, 2013 at 12:41 pm
3ms is the tollerance for a datetime data type.
why are you using implict transactions.
as in most cases, taking control yourself, using explicit transactions ( begin tran .... commit/rollback ) can make your applications impact footprint smaler.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 26, 2013 at 12:42 pm
What is the actual SQL operation? A series of inserts, updates or deletes? I single query? You never said.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 26, 2013 at 7:11 pm
ekant_alone (1/25/2013)
i have attached an image with this thread. my application is using jdbc drives. same operation in oracle is taking 3 secs but in SQL server it is taking 2mins.I took a profiler trace. seems like after every implicit transaction on/off operation i am losing 3 milli seconds. Does any one know why? and how to fix this?
Sounds like RBAR. Credits to Navy beans says you're trying to use a cursor or while loop. Please post the query.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply