Versions des environnements
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
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