InnoDB vs MyISAM
Okay so I'm in a dilemma for choosing which table type to use... Both have features I want...
On the one hand MyISAM supports FULL-TEXT Searches which are very useful.
On the other hand InnoDB tables allow for TRANSACTIONAL coding
(The locking of table rows during inserts, updates, and deletes and being able to rollback changes if not all of the sql queries are executed)
What would you recommend and why?