Displaying 2 results from an estimated 2 matches for "df_onep".
Did you mean:
df_new
2007 Jan 26
0
FW: reducing RODBC odbcQuery memory use?
...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 step as below. This c...
2008 Mar 03
0
reducing RODBC odbcQuery memory use?
...l 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 prior step as below....