>I've got a stored procedure that I'm trying to execute from a VFP program. If I execute the stored procedure from Query Analyzer takes less than 1 second. However, the same call performed as a SQL passthru from within a VFP application could take anywhere between 14~40 seconds. What would account for the delay?
Is the stored procedure returning a lot of data? Are you executing the stored procedure from a machine other than the SQL server? Are you running SSMS on the sql server?
Something that returns a lot of data locally on the SQL server may perform much differently if it has to send the data across the network or worse outside of the network (VPN, etc).
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________