Just to add to the previous message: ad_data_new table has less than 10 columns.
Anirudh Kondaveeti <https://sites.google.com/a/asu.edu/anirudh-kondaveeti/> Senior Data Scientist Pivotal (EMC) On Mon, Jun 23, 2014 at 4:15 PM, Anirudh Kondaveeti < anirudh.kondave...@gmail.com> wrote: > Hi All, > > I am using RPostgreSQL to pull data from Greenplum database. I have > successfully connected to the database and am using the following command > to retrieve the first 100 records from a table by the name "ad_data_new" > > s <- dbSendQuery(con, "select * from ad_data_new limit 100") > > This is taking more than 15 minutes to execute. The original table has > ~100,000 rows. At the current rate, it wouldn't be feasible to pull the > data into R using the above command. > > Any suggestions on improving the performance ? Or do you experience the > same performance as well ? > > > [[alternative HTML version deleted]] ______________________________________________ R-help@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 and provide commented, minimal, self-contained, reproducible code.
