Re: server on development machine

[Peter Brawley]

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 :-).