Answer to my own question: ush <- data.table(read.csv(...)) setkey(ush, product_id) s1 <- ush[J[product.id]]
> user system elapsed > 0.000 0.000 0.003 > It seems like that's the method to use! Amazing. -- View this message in context: http://r.789695.n4.nabble.com/Data-Frame-Search-Slow-tp4096906p4097576.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.