See how to join two data sets by one or more common columns using base R’s merge function, dplyr join functions, and the speedy data.table package. R has a number of quick, elegant ways to join data ...
I have a MySQL (yes, I know) database with two relevant tables, t with 52230 rows and r with 5 rows. r has primary key r_id and t has foreign key r_id -> r.r_id. I have indices on (t.r_id), (t.date), ...