.Net Sql Client Provider
- by sameer
Have come across a situation where in, if a stored procedure is executed in Query Analyser its execution time is less than a second. But when same Stored Procedure is executed using .NET Sql Client Provide. it is taking 61 seconds.
Therefore inorder to troubleshoot this issue we went to SQL Profiler we find the request come to SQL Server less then a second but execution completed after 60 seconds.
Can anybody suggest why we have such a deviation.
Query is a simple as give below
SELECT distinct p1.productID, p1.description
FROM Details V
INNER JOIN Product P
ON V.ProductID=P.ProductID
INNER JOIN product p1 on p1.productID=p.parentID
WHERE V.MarketID='1159' AND
V.FinancialYear='1213' AND
V.LEPeriodID= '75' AND
p1.parentID=100024 AND
p1.statusID = 1
ORDER BY description
