>In VFP 8, if I simply:
>
>s=seconds()
>c=sqlconnect('sql')
>=sqlexec(c,'open_inventory 11222','temp')
>?seconds()-s
>
>it takes about 1.3 seconds to execute the stored procedure.
>
>If I go into Query Analyzer and type:
>
>open_inventory 11222
>
>it instantly returns the query (probably less than .1 seconds).
>
>Any idea why VFP is so much slower?
Well, a few things...
One, the above is timing the time to connect and to run the query. I assume in QA you are just talking about the query time. Change your code to:
c=sqlconnect('sql')
s=seconds()
=sqlexec(c,'open_inventory 11222','temp')
?seconds()-s
Two, how is your connection set up? Does it use (local) as the server name?
BOb