[R] Error: cannot allocate vector of size

[xin123620]

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.