Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

[lau ch]

From my experience, Rick James's mulitple rows insertion in a single insert stetement can help a lot.

In addition, apart from just use one single session to do the insertion, you may also consider use muilt-session/multithread to do the insertion simultanuously. My test result is that it can insert 80M records within 4 hours for a table with ~60 fields plus 5 indexes.

However, I also experience the problem that when the table get larger, the insert rate get slower in a exponential rate. Rick James, do you have any idea for this problem? ("iostat -dx" return 70% io written)

Thanks,