>Hi All:
> When I execute a EXECUTE (EXECUTE[acctdata]) sql command from my VFP application, it takes 10 minutes return the results. However, when I run the store procedure from the sql, it takes only 3 minutes to return the results. Is there a way I can improve the speed of my EXECUTE command when run from VFP?
>Thanks
I think the reason Execute command is slower because it first have to complie the code to be executed.
In my ecperience running a procedure is always faster than using ExecuteScript in VFP (I assume Execute sql command works the same way as executescript in VFP)
The time difference seems very large.
Have you looked into making the code faster(optimized)?
Is there a trafic jam on your network that is slowing you down?
If speed is important I would use the stored procedure.
Well that was just my 2 pennies worth
Einar
Semper ubi sub ubi.