Michael, If the database is twice the size, how will that affect performance? I don't use full-text searches, so that shouldn't be a problem.
Thanks, Dan -----Original Message----- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: Re: Record Lock? On Sun, Dec 08, 2002 at 12:06:53PM -0800, Richard Reina wrote: >> How do I switch from MYISAM to InnoDB? Are there any negative >> implication in swithing? > > ALTER table TYPE=InnoDB; It will take twice as much disk space or thereabouts and not support full text queries. SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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