I've been playing with loading the data dumps into MySQL using C#, but even my best attempts still take hours to complete. This question indicates that it can be done in under 10 minutes when pushing the data into MS SQL.
I've commented out the
cmd.ExecuteNonQuery() statement which issues the
INSERT query and that knocks the time down to just under two minutes. I'm not sure what I'm doing wrong with the database, so I'm wondering if it's just differences between MySQL and MSSQL that are causing the delay, or if it's something I'm doing really, really wrong (I'm assuming the latter is more likely).
I already have a question on StackOverflow regarding the best way to load this data, but it's not exactly getting any attention (hopefully the bounty helps things a bit). What I'm wondering is if there are any statistics on "good" load times using other databases. I'd imagine a large number of folks on meta will have played with this data using a variety of different platforms. Perhaps we could compile some statistics for this?