I am writing an application which requires FULLTEXT indexing capability, and ACID transaction support would also be a plus. I am currently developing on MySQL 4.0.1.
As I understand it, MyISAM tables support FULLTEXT indexing but do not support ACID transactions. Also, InnoDB tables support ACID transactions but do not support FULLTEXT indexing. Is this correct? Is there another table type I can use to enable both FULLTEXT indexing and ACID transactions or is there some sort of workaround? Also, as a side issue, is anyone able to compare the pros and cons of MyISAM / InnoDB (or is there a good online resource?) Many thanks, from Duncan Maitland [EMAIL PROTECTED] --------------------------------------------------------------------- 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