Thanks for the question, Alexandre.
Asked: November 29, 2022 - 3:18 pm UTC
Last updated: January 13, 2023 - 2:20 am UTC
Version: 19c
Viewed 1000+ times
You Asked
Hi
Im looking towards ways for lowering latency and increase troughtput between database servers and web servers, but i couldnt find much of a straight documentation reagarding if Oracle driver could work in a UDP mode or in a lower stringent network mode to speed up my processes.
Any ideas?
Im looking towards some kind of direct network attachment, or even some kind of Remote DMA mode that the driver could work . Any idea of alternatives would be great
(connection pooling is already on the way to implementation)
Thanks!
and Connor said...
I'm not really a network guy but generally the things that hurt latency *within* a data centre are:
- distance (ie, two servers next to each other does not always been the network between them is also that distance :-))
- hops (excessive switches between components, each one adds a tiny overhead)
- noisy neighbours (servers sharing a network)
All of those things generally dominate more than things such as the protocol.
However, if all of those avenues have been exhausted then Oracle offers thing like connectivity of infiniband although that seems to be falling out of favour for RoCE which you could explore. But that is going to involve hardware solutions
Others welcome to share their thoughts if they've done this in the data centre.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment