Dear R Users, I was using R to import five years traffic data, but the error always come up as shown below. The data frame contains 12 columns and unknown number of records. Would you have any ideas that how I should deal with this situation? Many thanks for any hints.
>wim<-sqlQuery(channel,qry) Error: cannot allocate vector of size 24.0 Mb In addition: There were 16 warnings (use warnings() to see them) >memory.size(max=T) [1] 1535.62 >memory.size(max=F) [1]16.24 >gc() used (Mb) gc trigger (Mb) max used (Mb) Ncells 141802 3.8 6160587 164.6 5130092 137.0 Vcells 1100479 8.4 200894152 1532.8 184314496 1406.3 Best, Chengxin -- View this message in context: http://r.789695.n4.nabble.com/Error-cannot-allocate-vector-of-size-tp3629384p3629384.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.