Win a copy of Java XML & JSON this week in the XML and Related Technologies 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
  • Liutauras Vilda
  • Devaka Cooray
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

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

 
Ranch Hand
Posts: 65
  • 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?

 
Master Rancher
Posts: 3887
45
  • 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.
 
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database
https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!