Displaying 3 results from an estimated 3 matches for "psmrd".
Did you mean:
smrd
2007 Jan 25
1
Size of data vs. needed memory...rule of thumb?
...2-5GB
generally.
Here'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 102...
2007 Jan 26
0
FW: reducing RODBC odbcQuery memory use?
...ems oddly high to me) of virtual memory to execute the sqlQuery
command.
3. concluded the high memory use is isolated to the odbcQuery step w/in
the sqlQuery function as opposed to sqlGetResults or ODBC itself.
Relevant R session transcript:
>library(RODBC)
>channel<-odbcConnect("psmrd")
>df_OnePer <-data.frame(sqlQuery(channel, "select * from
AUTCombinedWA_BILossCost_1per"))
>save(df_OnePer, file = "df_OnePer.rda")
Additional testing details:
I exited R which released all memory cleanly, then started R again,
loaded the .rda saved in prior st...
2008 Mar 03
0
reducing RODBC odbcQuery memory use?
...gh to me) of virtual memory to execute the sqlQuery command.
concluded the high memory use is isolated to the odbcQuery step w/in the sqlQuery function as opposed to sqlGetResults or ODBC itself.
Relevant R session transcript:
>library(RODBC)
>channel<-odbcConnect("psmrd")
>df_OnePer <-data.frame(sqlQuery(channel, "select * from
AUTCombinedWA_BILossCost_1per"))
>save(df_OnePer, file = "df_OnePer.rda")
Additional testing details:
I exited R which released all memory cleanly, then started R again, loaded the .rda saved in...