Displaying 3 results from an estimated 3 matches for "fivep".
Did you mean:
filep
2007 Jan 25
1
Size of data vs. needed memory...rule of thumb?
...ere's details, just for context, or in case I'm misinterpreting the
results, or in case there's some more memory-efficient way to get data
in R's binary format than going w/the data.frame.
R session:
> library(RODBC)
> channel<-odbcConnect("psmrd")
> FivePer <-data.frame(sqlQuery(channel, "select * from
AUTCombinedWA_BILossCost_5per"))
Error: cannot allocate vector of size 2000 Kb
In addition: Warning messages:
1: Reached total allocation of 1023Mb: see
help(memory.size)
2: Reached total allocation of 1023Mb: see
help(memory....
2007 Jan 26
0
FW: reducing RODBC odbcQuery memory use?
...ame directly. I think you need to tell
RODBC to translate your 'byte-sized factors' to numeric, as it will be
going through character if these are a type it does not know about.
> R session:
> > library(RODBC)
> > channel<-odbcConnect("psmrd")
> > FivePer <-data.frame(sqlQuery(channel, "select * from
> AUTCombinedWA_BILossCost_5per"))
>
> Error: cannot allocate vector of size 2000 Kb
> In addition: Warning messages:
> 1: Reached total allocation of 1023Mb: see
> help(memory.size)
> 2: Reached total allocat...
2008 Mar 03
0
reducing RODBC odbcQuery memory use?
...rectly. I think you need to tell RODBC to translate your 'byte-sized factors' to numeric, as it will be going through character if these are a type it does not know about.
> R session:
> > library(RODBC)
> > channel<-odbcConnect("psmrd")
> > FivePer <-data.frame(sqlQuery(channel, "select * from
> AUTCombinedWA_BILossCost_5per"))
>
> Error: cannot allocate vector of size 2000 Kb
> In addition: Warning messages:
> 1: Reached total allocation of 1023Mb: see
> help(memory.size)
> 2: Reached total...