# Billion-row benchmark?

**URL:** <https://discourse.julialang.org/t/billion-row-benchmark/108417>\
**Category:** Performance\
**Tags:** benchmark\
**Created:** [January 5, 2024, 7:43pm UTC](https://discourse.julialang.org/t/billion-row-benchmark/108417 "2024-01-05T19:43:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![djholiver](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/djholiver/32/50470_2.png) [@djholiver](https://discourse.julialang.org/u/djholiver)\
**Post date:** [January 5, 2024, 7:43pm UTC](https://discourse.julialang.org/t/billion-row-benchmark/108417/1 "2024-01-05T19:43:20Z")

</div>

You’re correct - I had no intention to compare with Python or start a debate - the extract was to highlight that he either didnt know of Julia or didnt consider it (despite aggrievances with Python).

In so far as the benchmark - the article opens with the “one billion row challenge” with corresponding [link](https://github.com/gunnarmorling/1brc/discussions/categories/show-and-tell) that doesnt appear to have a Julia entry.

Regards,

---

<div class="post-metadata">

**Author:** ![stevengj](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/stevengj/32/71_2.png) [@stevengj](https://discourse.julialang.org/u/stevengj)\
**Post date:** [January 5, 2024, 11:13pm UTC](https://discourse.julialang.org/t/billion-row-benchmark/108417/2 "2024-01-05T23:13:15Z")

</div>

A post was merged into an existing topic: [Article - How fast is your programming language](https://discourse.julialang.org/t/article-how-fast-is-your-programming-language/108405/9)

---

<div class="post-metadata">

**Author:** ![rdavis120](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@rdavis120](https://discourse.julialang.org/u/rdavis120)\
**Post date:** [January 5, 2024, 10:45pm UTC](https://discourse.julialang.org/t/billion-row-benchmark/108417/3 "2024-01-05T22:45:03Z")

</div>

The one billion row csv file can easily be processed in Julia using the existing [duckdb](https://rmoff.net/2024/01/03/1%EF%B8%8F%E2%83%A3%EF%B8%8F-1brc-in-sql-with-duckdb/) entry. Obviously that solution doesn’t use CSV.jl. In my experience when running the same duckdb query, Julia started with multiple threads will be faster than python to return the results.