In real world example we won't execute insert query like that. You can try duckdb copy statement or insert into select statement in order to insert or copy data from a larger csv or parquet file. For me it is working blazing fast. I'm using from 0.7 and upgraded till version 0.9, I can see improvements in queries from version to version. I am using duckdb for data pipeline as well as creating dashboard from a larger data. The parquet files I am using contains millions of rows and duckdb does blazing fast insert and analytical queries.
Man I'm lovin your first try series!
I like trying new stuff new tech and I found these videos refreshing.
In real world example we won't execute insert query like that. You can try duckdb copy statement or insert into select statement in order to insert or copy data from a larger csv or parquet file. For me it is working blazing fast. I'm using from 0.7 and upgraded till version 0.9, I can see improvements in queries from version to version.
I am using duckdb for data pipeline as well as creating dashboard from a larger data. The parquet files I am using contains millions of rows and duckdb does blazing fast insert and analytical queries.
Thanks I'll have to give it a try