I have noticed significant speed difference between SPT and CursorAdapter data retrieval for parameterized SQL.
I tried "SELECT * FROM OrderDetail WHERE OrderID = ?VP_OrderID" with SQLEXEC() and CursorAdapter. CursorAdapter.CursorRefresh() takes 2-3 seconds to retrieve 2 rows. While SQLEXEC() retrieves them in no time.
Has anyone noticed this too?
I took the following T-SQL from SQL Profiler.
SQLEXEC()
---------
exec sp_executesql N'select * from orderdetail where OrderID = @P1 ', N'@P1 float', 1.400000000000000e+001
CursorAdapter.CursorRefresh()
-----------------------------
declare @P1 int
set @P1=-1
exec sp_prepexec @P1 output, N'@P1 int', N'SELECT * FROM orderdetail WHERE OrderID = @P1 ', 14
select @P1
- Jayesh