There is a "one billion row" benchmark thing going on and @eddelbuettel and others have done it in the context of #RStats: https://mastodon.social/@eddelbuettel/111710067033033953

I was interested, what base R solutions can achieve (only up to N=1e7, cause still on holiday computer). I honestly thought aggregate would work best and I had no faith in tapply...