Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What does 'Precompile SQL on Backend server' mean?
Message
 
À
24/10/2001 14:45:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00571374
Message ID:
00572835
Vues:
37
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform