[R] memory blues

[Bernie McConnell]

G'Day again,

I am attempting to read a large MSAccess file into R,  but get memory
problems.  With the first 100 rows of the table ("Macca99") things, as
shown below, are fine and the resulting object is 33,780 bytes.  But when I
read the entire table ("MaccaDiv99") which is 218,000 rows  R falls over
with the message:

Rgui.exe - Application error
The instruction at "0x025d0458" referenced memory at "0x0000003a".
The memory could not be "read"

My arithmetic suggests that the resulting object should have been about
 33,708 * 218,000 / 100 = c. 74 Mbytes.  I'm running Win NT with 256 Mbyte
memory so I was expecting to be able to read in the entire table.  Or am I
being hopelessly naive?

Many thanks

Bernie McConnell

> library (RODBC)
> options("dec",".")
$dec
[1] "."

$.
NULL

> theChannel <- odbcConnect("Ellies", "", "") 
> p          <- sqlFetch(theChannel, "Macca99") 
> odbcClose(theChannel)
[1] 1
> object.size(p)
[1] 33780
> 
> R.Version()
$platform
[1] "i386-pc-mingw32"
$arch
[1] "x86"
$os
[1] "Win32"
$system
[1] "x86, Win32"
$status
[1] ""
$major
[1] "1"
$minor
[1] "2.2"
$year
[1] "2001"
$month
[1] "02"
$day
[1] "26"
$language
[1] "R"


Bernie McConnell
NERC SEA MAMMAL RESEARCH UNIT
Gatty Marine Lab, St Andrews University
St Andrews, Fife,  KY16 8LB, Scotland.

b.mcconnell at smru.st-andrews.ac.uk
http://www.smru.st-and.ac.uk
tel:  	+44 (1334) 463280   
fax:  	+44 (1334) 462632   


                
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._