I want to design a forum script with MySql. Which database engine would have better performance? MyISAM or InnoDB ?
closed as off-topic by Mark Storey-Smith, Max Vernon, Phil, StanleyJohns, Mat Aug 31 at 5:15
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mark Storey-Smith, Max Vernon, Phil, StanleyJohns
Always use InnoDB by default.
There are cases where MyISAM is faster, but these cases are becoming more and more rare. For instance, doing table-scans. Or
|show 2 more comments|