Help #rstats folk.
I want to write, say, a 1m row dataframe to a SQL database 100k rows at a time. Any one have pointers or code or advice on best way to do that? Eg in batches in a *cough* loop or something that isn't a loop preferably.
3
2
1
The quote below is from the @duckdb documentation, but holds in general: don't use `insert` for bulk operations.
Rather look at the _specific_ documentation for _your_ SQL backend and see what it recommends for bulk.
Or else just be very patient.
Mar 12, 2022 · 7:20 PM UTC
1
2