Aw: Re: Change storage engine to InnoDB

[Stefan Kuhn]

> I restored a 700M gzipped dump on MyISAM tables and it took 20 minutes.
> I then replaced the CREATE TABLE statements to use InnoDB, the same restore on the
> same machine took 105 minutes.
> Not a big improvement, isn't it?
> Am I missing something?

I doubt that insert alone (which is what the dump restore does) is a good measurement for
performance. The improvement might be (and, you could say, should be) more in the
selects.