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:<jdnewmil@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.dai@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]]

