Re: server on development machine
Posted by: Peter Brawley
Date: July 02, 2021 01:09PM

A footnote about WB import speed ... the WB import wizard took in 200k rows in 5 mins?

MySQL import methods in descending order of speed ...

1 Load Data Infile using parallelism with MySQL Shell

2 standard Load Data Infile

3 Inserts with multiple Inserts per statement (eg mysqldump scripts with extended inserts)

4 Inserts with single Inserts per statement

Using method 3 on a modest modern laptop with MySQL installed on an SSD, I see import speeds of 40k rows/sec. There's some optimising work ahead for you :-).

Options: ReplyQuote


Subject
Written By
Posted
Re: server on development machine
July 02, 2021 01:09PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.