A) You haven't mentioned your OS which indicates you haven't followed the posting guide noted at the bottom of each email.
B) You cannot load an "unknown" number of rows... although you may not specify the number, it is finite and its value can be determined for the purposes of debugging your immediate problem by examining your data.in its external storage. Please investigate and inform us. --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity. xin123620 <chengxin....@gmail.com> wrote: 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. [[alternative HTML version deleted]]
______________________________________________ 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.