Hi,
I'm trying to query around 9M rows from our database. Sometimes it was successful but most of the time crashes. I am using simple code to run this:
library(DBI)
library(RMySQL)
con <- dbConnect(RMySQL::MySQL(),
dbname = 'database',
host = 'server.ip',
port = 'port',
user = 'my_user',
password = 'my_pass')
query <- 'select * from My_table'
sendQ <- dbSendQuery(con, query)
my_files <-dbFetch(sendQ, n = -1)
5mins after I ran dbFetch() it crashes. Is it because I tried to get large amount of data? Is it the specs of my PC affects on this as well?