3 ms·

DuckDB is a columnar database so computing the sum of one column should be really fast. Yet it requires more than a minute for 280k rows? That seems way too slo

DuckDB is a columnar database so computing the sum of one column should be really fast. Yet it requires more than a minute for 280k rows? That seems way too slow so probably just a limitation of the shared file system.

hobs 3y ago
It's metadata, so comparing how good a count(*) is is pretty pointless.
- petters 3y ago
  I agree that the article is not very good
- rcarmo 3y ago
  Especially since SQLite would give a near-instant reply if there was an index in the table. The entire example is wrongly reasoned from start to finish.