search for: dbres

Hi, I use the ROracle interface in the R 64bit version. When I fetch a large number of rows from the database I get alternating 250 rows of what I want to see and than 250 rows junk and so on. It does not matter whether I use the fetch command or dbGetquery or whatever. My fetch_default_rec = 500 and I can not change it by setting it explicitly in Oracle(). Any idea what's the problem

Hi Does anybody know how to create ff objects with data reading from stream objects, such as data reading from PostgreSQL database through RPostgreSQL. For this purpose although we can save the data to a csv file through external tools and then read it through csv readers, but it requires one more data read and write operation, which is of high I/O cost for large datasets. Xiaobo.Gu