Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance optimization when using cursor adapters
Message
De
06/03/2006 13:57:39
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01101782
Message ID:
01101788
Vues:
11
Once I have the data in the cursor adapter and I am using the cursor adapter in sql queries will sys(3054,x) work?

Jason

>>I am looking at doing some performance analysis and optimization in my application and have been reading about sys(3054,X) and rushmore optimization. The documentation mentions tables. I am using cursor adapters to access an ORACLE database. I tried using sys(3054,X) functions but it did not display anything.
>>
>>So I am wondering whether sys(3054,X) is usable with cursor adapters.
>>
>>Could someone point me in the right direction to work on optimizing the speed of my application.
>>
>>Thanks
>>Jason
>
>SYS(3054,x) is useable with CAs but only if datasourcetype = NATIVE, then SYS(3054) works, but if you any other type this function is unusable. You should use Tools that comes with DB you use to test your queries and see how to optimize them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform