4 ms·
For the table you have 3 integer rows and a char(6) row. Taking integer as 32 bit that is a total of 18 bytes of data per row. At billion rows, that is 18GB of
by nojvek 5y ago
For the table you have 3 integer rows and a char(6) row. Taking integer as 32 bit that is a total of 18 bytes of data per row.
At billion rows, that is 18GB of data. With some overhead for storing page info, let’s call it 20GB flat.
A modern SSD can deliver ~500MB/s write speed. That means writing 20GB of data can be done in 40 seconds.
Therefore a billion rows in a minute is quite plausible. At-least not bottlenecked by disk speed (if we can saturate disk).
- sharken 5y agoIt's a good insight to know what the hardware is capable of. The SSD in the authors machine can do 1300MB/s and the latest M1 model can do 2100MB/s. For current gen SSDs with PCIe 4.0, that number increases to 6600MB/s for the Sabrent Rocket 4 Plus. That would mean just around ~5 seconds for writing to disk. https://www.pcgamer.com/best-pcie-4-ssd-for-gaming/ https://www.pcgamer.com/best-pcie-4-ssd-for-gaming/
- patrec 5y ago> A modern SSD can deliver ~500MB/s write speed. More like ~5GB/s.