I'm working with a huge database and since I've started R is having problem computing the operation that I wrote. This error does not always appear but in particular it is encountered when I try to upload a file in .xlsx format that is 41.4 Mb (12000 column and 1000 rows approximately).
The following is the error that I get:
"Cannot Connect to R
RStudio can't establish a connection to R. This usually indicates one of the following:
The R session is taking an unusually long time to start, perhaps because of slow operations in startup scripts or slow network drive access.
RStudio is unable to communicate with R over a local network port, possibly because of firewall restrictions or anti-virus software.
Please try the following:
If you've customized R session creation by creating an R profile (e.g. located at ~/.Rprofile), consider temporarily removing it.
If you are using a firewall or antivirus software which guards access to local network ports, add an exclusion for the RStudio and rsession executables.
Run RGui, R.app, or R in a terminal to ensure that R itself starts up correctly.
Further troubleshooting help can be found on our website:
Troubleshooting RStudio Startup"
I would like to ask the community suggestion about working on such large data.
Just for info, I'm working with Ubuntu 18.4.5