Different performance in QA and ADO.NET

[Erik]

Hi!

I have a stored procedure that when I execute it in Query analyzer executes
in 1.2 seconds. When the same sp executes from .NET C# the duration is 6.8
seconds. I'm using profiler to measure the duration of the sp.

Have anyone experienced anything like this?

Regards

Erik

 

[Pablo Castro [MS]]

Hi Erik,

Make sure you have the exact same session environment. For example, SET
ROWCOUNT will affect the plan chosen by the server; other "SET"s can affect
it as well.

Is this something you can reproduce easily? If so and you can provide me
with the database schema, the sp and the code you're using for the
invokation I'll be glad to take a look.

Thanks,

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Erik]

Sorry to have bothered you all, some developer in our team used the string
instead of StringBuilder when retriving xml from the sp using the
datareader... problem solved!

Thanks anyway!