Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thanks for your help
>>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
>Hello Marshal
>I did not detected speed exeleration for local views
>Best wishes, Vladimir
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement