Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What does 'Precompile SQL on Backend server' mean?
Message
 
To
24/10/2001 14:45:29
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00571374
Message ID:
00572835
Views:
38
>Hi!
>
>I read the help for SQLPrepare() function but it still seems like chinese to me, in other words, what I understand is that I can use the function to compile a SQL command used with the SQLExec() function. But, I use views a lot so I don't think it will be of help to me. Am I wrong?
>
>TIA
>
>Luis
>
>
>
>>Hi!
>>
>>Take a look to the help for SQLPrepare() function. The option you mentioned works by the same way for remote views as SQLPrepare() function.
>>
>>>
>>>Luis

Luis;

You can use SQLPrepare() which is compiled for faster execution, before using SQLEXEC( ). You can also use SQLEXEC( ) by itself, which will work but you may loose a bit of speed. You can try both techniques and see if there is any real difference in your application.

Tom
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform