TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Lessons learned from doing the one billion row challenge

29 点作者 anthony88大约 1 年前

4 条评论

sampo大约 1 年前
&gt; My implementation ... All the results are incorrect. The station names should be sorted alphabetically but the last station showing is İzmir and it should be Zürich.<p>It is easy to forget, that names of places can have non-ASCII characters. As this is a speed contest, I wonder how slow the default library implementation for ordering unicode strings alphabetically is in Java?<p>Edit: Apparently there is no universal way to order words alphabetically, but it depends on the (human) language in question.<p>For example, İzmir is in Turkey and in Turkish alphabetical ordering the dotted capital İ comes after the dotless capital I. And in Turkish, Ö comes right after O, but for example in Swedish, the Swedish special letters Å, Ä and Ö are at the very end of the alphabet.<p>How are you supposed to deal with this in this contest? Are you somehow supposed to know that Özalp is a town in Turkey, and thus comes after O in alphabetical ordering, but Örebro is a town in Sweden and should be ordered to the very end of the alphabetical ordering, after Z and Å and Ä?
评论 #39516056 未加载
评论 #39516028 未加载
评论 #39516304 未加载
kubb大约 1 年前
JVM arguments as an optimization technique give me that winter melancholy.
NicoJuicy大约 1 年前
This is weird. I&#x27;ve read about the 1brc and the first thing I remember is that you need to establish the base result in your pc vs. The metric and then normalize the results to that benchmark.<p>This post doesn&#x27;t seem to take that into account.
netcraft大约 1 年前
Is anyone doing the challenge on other platforms besides java?
评论 #39518353 未加载
评论 #39515844 未加载