>>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).
Thanks.
No VPN, just a simple LAN configuration. The result set is only 59 records.