Hello fellow RStudio lovers!
We are having massive performance issues when querying our Oracle DB from Rstudio (Pro) using ROracle package.
Basically whenever you run a query:
- It works (which is a good start)
- But the session is lagging a lot: you can't even open a file from the browser until the query is finished, and don't even think of running 2 sessions at the same time because if you do then both of them just freeze completely
Any idea how this could be improved or any other package anyone could suggest to fetch from Oracle?