On 8/20/07, Davide Alberani <[EMAIL PROTECTED]> wrote: [...] > 5. > Time to alter the table (with indexes), converting from MyISAM > to InnoDB: 77 min, 29 sec. > > Total time to create a database using MyISAM and then converting it > to InnoDB: 1h 55m 17s. > Looks like this one is the best option.
Yep, thanks for doing all these tests! :) Should be simple to add an option to do that automatically after completing the import, I guess. > > Now... does anyone know if there's a single SQL statement to > convert every table of a database from MyISAM to InnoDB? As far as I know there is no such statement... -- Vetle Roeim ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
