When you have a table with both numeric and variable-length text data, and you need to update the numeric part a lot, it made sense in MyISAM to split the numeric from the textpart. (Because working on fixed-length tables is so much faster.) Say...
Original: Table 1: id1 int, id2 int, articletext text MyISAM optimized: Table 1: id1, id2 Table 2: id1, articletext (primary key on id1) Does the same go for InnoDB tables? Or would the original table be just as fast? (Or perhaps faster) sql,query --------------------------------------------------------------------- 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