Redshift Import 2h for 13000 rows
已回答
I used Data import feature and it took 1h 53m to import 13 000 rows with only one column. Any idea why?
请先登录再写评论。
@ Dawid Nawrot ,
RedShift JDBC driver doesn't support batch inserts. Now IDE implements 13K inserts one by one.
Follow Amazon Redshift Best Practices for Loading Data https://docs.aws.amazon.com/redshift/latest/dg/c_loading-data-best-practices.html
Makes sense. Thanks for prompt reply. I will use COPY command from S3 from now on
We will implement batch inserts when Amazon implements this feature in JDBC driver.