Whoops, originally sent this to just Heikki. > On Monday, February 11, 2002, at 12:12 PM, Heikki Tuuri wrote: > >> for InnoDB 'dynamic rows', that is, rows where you define char columns as >> VARCHAR, are faster because tables and indexes fit in smaller space. > > Is there reasoning specific to InnoDB? Dynamic tables would be smaller > regardless of the table type, I would think. In Kaj Arno's talk on > optimizing MySQL at the O'Reilly Open Source Convention last year, he said > that fixed tables are preferable and that if you must have dynamic columns, > you should try to put them in a table separate from your static columns > (slides 67 and 68 for those who have them). Has this changed?
David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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