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.

Reply via email to