• 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
  • Bear Bibeault
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Frits Walraven
Bartenders:
  • Carey Brown
  • salvin francis
  • Claude Moore

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

 
Ranch Hand
Posts: 108
  • 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: 4042
47
  • 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.
 
Those cherries would go best on cherry cheesecake. Don't put those cherries on this tiny ad:
Create Edit Print & Convert PDF Using Free API with Java
https://coderanch.com/wiki/703735/Create-Convert-PDF-Free-Spire
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!