Hi Darren,
It's possible that connecting to SQL Server in VFP takes most time. In the Query Analyzer connection is alread established. Try
s=seconds()
c=sqlconnect('sql')
?seconds()-s
s=seconds()
=sqlexec(c,'open_inventory 11222','temp')
?seconds()-s
>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?
--sb--