Last post Feb 16, 2011 07:37 PM by Will Steele
Feb 16, 2011 04:16 PM|Will Steele|LINK
I have a query that I want to test the performance of when the query is included directly in the SqlDataSource versus when I call a stored procedure. Does anyone have suggestions on how I would be able to closely watch the actual steps here? I was thinking
of turning on tracing and adding Trace.Write for each of the events that fire along the way. This doesn't seem efficient and I wanted to see if there was a better approach.
Feb 16, 2011 04:42 PM|sansan|LINK
test the performance of when the query is included directly in the SqlDataSource versus when I call a stored procedure.
If you are trying to check execution time in your code, you can use
System.Diagnostics.StopWatch. Use DataSource select method to get data using query and do the samething with the procedure. That should give you exact execution time to compare performance.
Feb 16, 2011 07:37 PM|Will Steele|LINK
Great I'll look at that one. Thanks.