Investigate DuckDB Insert performance
The DuckDB adapter has very slow ingest performance due to using neither appenders nor batched inserts at the moment. This should be fixed but may be difficult due to the design of DuckDB. At the moment though DuckDB can't be recommended and SQLite should be used instead.