This week's book giveaway is in the Spring forum.
We're giving away four copies of Spring in Action (5th edition) and have Craig Walls on-line!
See this thread for details.
Win a copy of Spring in Action (5th edition) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Ganesh Patekar
  • Frits Walraven
  • Tim Moores
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Stephan van Hulst
  • salvin francis
  • Tim Holloway

REST API call taking more time than excuting a SQL on the Oracle SQL Developer  RSS feed

 
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In my REST API call, in the code, I've been calling some SQL statements like this based on the flag value supplied at the time of web service call. I am wondering if this is an inefficient way of calling different SQLs ? The reason I am wondering is, because, my webservice call is taking 80,000ms to execute this
particular webservice call. And when I typed the exact SQL in the Oracle SQL developer's SQL Worksheet, it took only 7.4 seconds (~7000ms). So, it doesn't look like a SQL issue to me or is it like REST API calls tend to take more time than directly executing the SQL on the SQL developer?

 
Rancher
Posts: 3748
40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How are you timing this?
I would suggest putting some monitoring logging in there so you can try and see where it is going slowly.
Also, ensure you log the query you are doing.
 
Well behaved women rarely make history - Eleanor Roosevelt. tiny ad:
Download Free Java APIs to Work with Office Files and PDF
htttp://www.e-iceblue.com/free-apis.html
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!