Re: [R] FF package & downloading a large file using sqlQuery

2012-09-17 Thread Jan
You can use the read.dbi.ffdf and read.odbc.ffdf function in package ETLUtils. These allow you to fetch a query directly in an ffdf. See the examples in their corresponding documentation ?read.dbi.ffdf and ?read.odbc.ffdf or look at this blog post http://www.bnosac.be/index.php/blog/21-readodbcffdf

[R] FF package & downloading a large file using sqlQuery

2012-09-06 Thread ramoss
I am new to R and am encountering memory issues while trying to download a large table from Green Plump, using sqlQuery. Is there any way this FF package can help me create a large dataframe in R while downloading from the server? The FF documentations are very confusing. Thanks for any help