bert hubert 🇺🇦🇪🇺 on Nostr: Testing out DuckDB versus sqlite on the Dutch election results (precinct/candidate ...
Testing out DuckDB versus sqlite on the Dutch election results (precinct/candidate level, millions of rows). DuckDB is a solid factor 7 faster, and correctly spotted problems in my SQL. Again very impressed.
Published at
2023-11-25 20:08:33Event JSON
{
"id": "bb9dd6144b6102b12ec7197504466d8e083b166ef5e3e6962f5b1f276ed12fc4",
"pubkey": "b2a729af72f53eaf7a64944a3b4fcc1a5c4e4476852b80513bf405183c484187",
"created_at": 1700942913,
"kind": 1,
"tags": [
[
"proxy",
"https://fosstodon.org/users/bert_hubert/statuses/111472994753785386",
"activitypub"
]
],
"content": "Testing out DuckDB versus sqlite on the Dutch election results (precinct/candidate level, millions of rows). DuckDB is a solid factor 7 faster, and correctly spotted problems in my SQL. Again very impressed.",
"sig": "75654f24ec60d17570f5cf9e26d24aa08067d69b4b8ff5dbcd81189dc06a8932c1bc59533bb753bc921926d78f8bc7ddba92f5bbba12a8e8b5fafb785906c6ec"
}
