3 ms·
Thanks zX41zdbW - I find the query you shared easier to reason about than: https://github.com/klausbreyer/hackernewsstats/blob/main/queries/count-years.sql htt
by tylerhannan 4y ago
Thanks zX41zdbW - I find the query you shared easier to reason about than:
https://github.com/klausbreyer/hackernewsstats/blob/main/queries/count-years.sql https://github.com/klausbreyer/hackernewsstats/blob/main/que...
Also:
"Elapsed: 0.140 sec, read 33.95 million rows, 1.26 GB."
140 ms is quite impressive.
- return_to_monke 4y agoto be fair, that is large part because CH seems to have a topLevelDomain function
- deleted 4y ago[deleted]