Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Proc runs slow in VFP
Message
 
 
To
22/12/2003 15:50:09
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00861404
Message ID:
00861410
Views:
19
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform