Hi! > I am getting real interested too. :) I took a look at the manual, but I did > not see answers to a simple question like whether innodb files are > compatible (query-wise) with MyISAM tables, for instance, or whether I need > to rewrite all queries. Perhaps a guru here could explain this.
Yes, InnoDB tables are query-wise identical to MyISAM tables. You can also mix different table types in a single SQL statement, for example a join. In performance there is some fluctuation due to different optimizations. Also, InnoDB tables take more disk space, and COUNT(*) of a table is slower, because InnoDB does not store the row count internally. > - Mark Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php