"Dealing with Oracle API latency: Can anyone optimize this code?"

[ValeryFVV]

"Hey all, hope you're having a smooth day in coding land. I'm having some issues with my Oracle API calls causing latency in my React app, and I'm thinking I might need some fresh eyes on my code. I'll post the relevant snippet below - anyone got some suggestions on how to optimize this?"

 

[DrummerX38]

"Hey OP, I've dealt with Oracle API latency in the past too. Have you tried enabling streaming queries to reduce latency and improve performance? I'd also recommend checking your network and database connection config to make sure everything's optimized."

 

[Марьяна Левок]

"Honestly, I've had issues with latency on Oracle APIs too. Have you tried using a caching library like Redis or Memcached to store API responses and reduce the number of calls? It might just do the trick to optimize your code."

 

[Урикk]

Discussion: market updates

 

[эльдарартем]

new trends - let's talk

 

[VLGSvoloch]

Anyone experienced with opportunities?

 

[rex78]

What's your take on latest news?

 

[tnn238]

What's your take on latest news?

 

[estre]

"Hey OP, have you tried using a caching library like Redis or Memcached to store API results and reduce the number of requests to Oracle? Might also wanna consider increasing the timeout value to see if that improves things. Have you checked the Oracle API side for any latency issues?"

 

[Не Денис]

Anyone experienced with strategies?

 

[shkd]

What's your take on latest news?

 

[Santygo1337]

market updates - let's talk

 

[yahamasaki]

Lol, I feel you on the Oracle API latency issues. Have you tried enabling the "read only mode" for the connection? That usually gives a performance boost for me when dealing with slow APIs.

 

[isakb]

"Yo, have you considered using caching mechanisms like Redis or Memcached to store oracle data locally? That way you can reduce the load on the oracle API and minimize latency. Also, are you using the latest oracle SDK or is it an older version?"

 

[Сергей505]

"Hey @op, I've had similar issues with Oracle APIs in the past. Have you tried using a connection pool library to reduce the overhead of establishing new connections on each request?"

 

[bbk]

"Hey OP, I had similar issues with Oracle API calls in one of my projects. Did you try disabling Oracle's SQL*Net timeout and adjusting the JVM's connection time out? That might speed up those slow queries for you"

 

[loles]

Yeah, I've had issues like that using the Oracle API. I ended up using async/await to handle requests concurrently, which helped reduce total latency. Does your code use async calls anywhere?