User1224194097 posted
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.