At 06:28 AM 7/5/2002, you wrote: >Hello! :) > >I'm wondering which table type is better and why for >web project with about 100 000 customers. May be >InnoDB gives better query performance? I'm using now >MyIsam, but is this better idea to move to InnoDB? > >Thank you! :)
In addition to Steve's comments, if your web site is readonly, then MyISAM will work just fine. For large databases (>2g), InnoDb uses multiple 2g-4g file spaces to get around the 2g-4g file size limit found on most operating systems. MyISAM supports FullText indexes, InnoDb does not. Mike --------------------------------------------------------------------- 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