Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Batch size one billion: SQLite insert speedups, from the useful to the absurd.
create table testInt(num Integer); WITH n(n) AS(SELECT 1 UNION ALL SELECT n+1 FROM n WHERE n < 1000000) insert into testInt select n from n;
On my machine - Mac Mini 3 GHz Dual-Core Intel Core i7 16 GB 1600 MHz DDR3
this takes Run Time: real 0.362 user 0.357236 sys 0.004530
create table testInt(num Integer); WITH n(n) AS(SELECT 1 UNION ALL SELECT n+1 FROM n WHERE n < 1000000) insert into testInt select n from n;
On my machine - Mac Mini 3 GHz Dual-Core Intel Core i7 16 GB 1600 MHz DDR3
this takes Run Time: real 0.362 user 0.357236 sys 0.004530