Link to home
Start Free TrialLog in
Avatar of Melodi Roberts
Melodi RobertsFlag for United States of America

asked on

utl_http efficiency over utl_dbws

One last question regarding utl_dbws:

I just tested the callout sto a webservice over https, comparing utl_http calls with utl_dbws calls. I found that processing times were more than twice as fast with utl_http over utl_dbws.  

Has anyone else experienced this? This could be a deciding factor in what to make the standard for development in our team for callouts.  Are there certain things to consider regarding the environment that may be causing utl_dbws to be so much slower?
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Melodi Roberts

ASKER

Thanks so much for the info.  We're probably going to develop a generic package for soap communications using utl_http instead of using utl-dbws.  When processing over 10K records, that extra overhead really adds up.
Just an additional note:  Found a generic soap package using utl_http already written and available at this site: http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.ph