3 ms·RStudio, interrogating a ~0.5 billion record dataset. A 192G Ram machine.by mike_ivanov 6y agoRStudio, interrogating a ~0.5 billion record dataset. A 192G Ram machine.jiofih 6y agoI did some benchmarking on that public taxi rides dump (~600m records) and could run through it all in under 15 seconds directly from SSD. No way in hell your CPU will keep up with anything close to memory bandwidth or beyond 3GB/s.jiofih 6y agoUsing Clickhouse btw.