Hello, I'm using RJDBC/DBI to query a MS SQL DB that looks like:
YMDHMs Num1stsAboveBaseline 2009-05-18 00:00 1 2009-05-18 00:01 2 2009-05-18 00:02 2 ... The first column will get converted to POSIXct. However, dbGetQuery converts the first column to a factor - which kills performance when I go against a production table with a few 100k rows. Using read.table() against the equivalent text file allows me to say "as.is = 1" resulting in characters. I don't see any equivalent in dbGetQuery (nor in dbSetQuery & fetch) What am I missing? TIA, Jim Porzak Ancestry.com San Francisco, CA www.linkedin.com/in/jimporzak use R! Group SF: www.meetup.com/R-Users/ ______________________________________________ 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.
