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:<

[hidden email]> 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 <

[hidden email]> 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.htmlSent from the R help mailing list archive at Nabble.com.

_____________________________________________

[hidden email] mailing list

https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide

http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code.

[[alternative HTML version deleted]]

______________________________________________

[hidden email] mailing list

https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide

http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code.