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?