4 ms·
Hm, maybe I need to run my tests again. > https://github.com/oracle/python-cx_Oracle/issues/555#issue-857081325 https://github.com/oracle/python-cx_Oracle/issu
by sonthonax 5y ago
Hm, maybe I need to run my tests again.
> https://github.com/oracle/python-cx_Oracle/issues/555#issue-857081325 https://github.com/oracle/python-cx_Oracle/issues/555#issue-...
This is what I saw for Oracle running on RDS. My ping was pretty stable: 500us.
What I found was that RDMSs are an order of magnitude slower even without the network latency.
- anarazel 5y agoI think it'd be good to put the different tests on a more comparable footing. E.g. comparing results of different services on hosts with different network latency isn't that meaningful. And the actual queries should be something roughly equivalent too.
- sonthonax 5y agoWell that test ran on EC2 against RDS in the same region. But the results were reproducible locally using docker. What I actually found, is that the timings given by explain plan were quite different from the reality, no matter how much I factored in network latency. Which makes me think there’s a massive overhead in actually sending the data.