>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?
Run SQL Profiler and check what VFP sends to SQL Server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.