I wouldn't expect to see much of a difference especially since the QA uses ODBC. Are you using the same login for both the app and QA? What happens if you force the stored proc to recompile?
-Mike
>We are executing a stored procedure from our VFP app using ODBC to connect to SQL Server 2000. We have discovered that one of the queries in the sp takes a significant amount of time to run when the sp is called from fox. When the sp is run in Query Analyzer, the one query that took a long time before now runs much faster (by an order of magnitude).
>
>We are at a loss as to what would cause this? Are there any issues with ODBC that would degrade performance? We analyzed this somewhat using Profiler and found that CPU usage is literally off the charts when the stored procedure is called from fox, but is normal when ran directly in QA.
>
>Any help you can provide is much appreciated.
>
>JDA