[R] Fetch large sized file from SQL

Corrado ct529 at york.ac.uk
Fri Oct 2 16:10:48 CEST 2009


I think you can specify the number of rows to be loaded at a time.  It was 
quite a while ago. Try reading

?sqlQuery
?odbcConnect

I have loaded quite large tables.

On Friday 02 October 2009 14:59:59 Dr. Alireza Zolfaghari wrote:
> But the problem is that the dataframe size in sql is large, therefore odbc
> can sqlQuery() can not handel it.
>
> On Fri, Oct 2, 2009 at 2:14 PM, Corrado <ct529 at york.ac.uk> wrote:
> > You can try using RODBC, it allows you to connect to databases using the
> > ODBC
> > driver.
> >
> > I had some difficulties using it with the postgresSQL driver in the past,
> > because of some apparent incompatibility with the native postrgesSQL ODBC
> > driver. I think the problem where solved by the new ODBC driver for
> > postgresSQL and the new revision for RODBC.
> >
> > On Friday 02 October 2009 13:56:02 Dr. Alireza Zolfaghari wrote:
> > > Hi List,
> > > Does any one know what package I need to use in order to fetch/get a
> >
> > large
> >
> > > sized dataframe from SQL? I have already used sqldf package which is
> > > good for fetching large sized csv files.
> > >
> > > Thanks
> > > Alireza
> > >
> > >       [[alternative HTML version deleted]]
> > >
> > > ______________________________________________
> > > R-help at r-project.org mailing list
> > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > PLEASE do read the posting guide
> > > http://www.R-project.org/posting-guide.html<http://www.r-project.org/po
> > >sting-guide.html>and provide commented, minimal, self-contained,
> > > reproducible code.
> >
> > --
> > Corrado Topi
> >
> > Global Climate Change & Biodiversity Indicators
> > Area 18,Department of Biology
> > University of York, York, YO10 5YW, UK
> > Phone: + 44 (0) 1904 328645, E-mail: ct529 at york.ac.uk



-- 
Corrado Topi

Global Climate Change & Biodiversity Indicators
Area 18,Department of Biology
University of York, York, YO10 5YW, UK
Phone: + 44 (0) 1904 328645, E-mail: ct529 at york.ac.uk




More information about the R-help mailing list