bullo (4/3/2012)
If I run this test against MS Access or MySql it takes aprox. 4000ms.If I run this test against Sql Server takes aprox. 8800ms. !!!!!!
why is that?? again...if I measure latency for each query, it will be faster in Sql Sever, but all page is slower....
thanks again. Munscio
Without seeing the actual calls, and what your code is doing with it on top of it, we can't answer you. The devil is in the details. It's like me asking you why each of my tires are faster between two cars but the faster car travels slower when put on the road. With nothing else to work from, you'll just stare at me and start asking questions.
Basically what we're doing; asking questions. It's too vague still.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA