Comment by educationdata

data.table can handle millions of rows easily, as long as the data can fit in the memory.