Hola Luis,

In theory, this option is supposed to compile your view's SQL statement on the backend to improve performance on _subsequent_ executions of the same query. In practice I don't think it actually does that.


>Thanks, but I really need to know what does 'Precompile SQL on backendserver' means. It is in the View Desginer's Advanced Options. And please, show me a real-world example if possible.
>
>Thanks any way.
>
>
>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