Re: MS SQL to MySQL 5 migration performance
Posted by: Damir Bulic
Date: August 13, 2009 01:35PM

MySQL is very fast with inserts. In our internal testing, loading data from text file wasn't significantly faster than doing extended inserts.
45 minutes for 5M rows is achievable. We got much faster transfer speeds, but this depends a lot on the network lag, and of course - size of each row.
Keep in mind two things:
1) you might run out of RAM if you are pulling data from SQL Server and inserting simultaneously
2) if you use sql inserts instead of data loading, make sure your script size is smaller than max_allowed_packet variable

And one final note - SQL Server is much faster than MySQL for complex transformations. For some things we did, it finished in seconds, while MySQL took 15 minutes or simply froze. That testing was some time ago, maybe the situation changed since.

--
Damir Bulic
Spectral Core (makers of Full Convert Enterprise)

Options: ReplyQuote


Subject
Written By
Posted
Re: MS SQL to MySQL 5 migration performance
August 13, 2009 01:35PM


Sorry, you can't reply to this topic. It has been closed.

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.