Hi Carlos,
>1. Do I get more perfomance if I use prepared = .T.?
>
Usually, you do get better performance if you use Prepared=.T. . There are two main factors here:
1) VFP doesn't reparse command for parameters during REQUERY().
2) Backend Server does whatever optimization it can offer, if any.
However, SQLPREPARE+SQLEXEC might take longer than non-prepared SQLEXEC.
The real performance gain depends from scenario. It all comes to how complex the command is, how much optimization is offered by the backend for subsequent executions, how often and how many times application reexecutes the same command.
If application calls the same command several hundred times in a loop, the performance gain might be significant, but if it calls REQUERY only from time to time, the performance gain might be unnoticeable. You just have to run some tests with your application and see whether Prepared=.T. really makes a difference for you.
Thanks,
Aleksey.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only