-
Why Oracle9i stored procedures are slower than direct Sql Query statements in VB,COM+
We are using VB6.0,ADO,COM,COM+ and Oracle9i Back end
The normal assumption we made is stored procedures are faster than direct Sql statements passed from connection or command object. After converting Sql statements to pakages and stored procedures and functions our application perform slower than before.
We have done PINING of packages.Hit ratios are above 99%, have 512MB RAM,SGA instance is 129MB.
The performance before using SP was 10Transactions per second
The performance after using SP is 7Transactions per second.
Can anyone explain how to improve performance,why the SPs are slower in COM,COM+ environment?
Thanks in Advance....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|