General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Vladimir,
Is there a difference in performance for Local Views?
>>Hi all,
>>
>>Will setting a View's Prepared Property to .T. actually make a difference in performance?
>For remote view it makes sence
>It works like calling compiled procedure at server
>Let we work through sqlexec
>and put some select sql incide it and put same select incide procedure at server and also put in sqlexec
>Second variant will work more fast
>For views setting the property you have mentioned will make something like precompile of sql sentence
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