Skip to content

read.table performance

2 messages · Gene Leynes, Gabor Grothendieck

#
On Tue, Dec 6, 2011 at 1:15 PM, Gene Leynes <gleynes at gmail.com> wrote:
You could also try read.csv.sql in the sqldf package and see whether
or not that is any faster. Be sure you are using RSQLite 0.11.0 (and
not an earlier version) with that since earlier versions were compiled
to work with only a maximum of 999 columns.

library(sqldf)
DF <- read.csv.sql("C:\\test.txt", header = TRUE, sep = "\t")

You may or may not have to use the eol= argument to specify line
endings.  See ?read.csv.sql