try preserve_insertion_order
Memory setting didn't work for big datasets. It took more time to process, rolling back and trying another configuration as recommended in https://duckdb.org/docs/guides/performance/how-to-tune-workloads#the-preserve_insertion_order-option
try preserve_insertion_order: Memory setting didn't work for big datasets. It took more time to process, rolling back and trying another configuration as recommended in https://duckdb.org/docs/guides/performance/how-to-tune-workloads#the-preserve_insertion_order-option