I have a stored procedure implemented and calling of this stored proc from web page is taking more than 300ms, But when write the script in the web page and call the url, it is executing in 50ms
What are the steps that are required to reduce the time to execute a stored proc. Why is sp taking more time than the db script in the page