Given a moderate sized forum ( 200000 + posts, 24000+ topics, 10000+ members 22000+ attachments ) would you opt for Innodb or MyISAM.
(Innodb + fulltext native ssearch) or (MyISAM + fulltext MySQL search)
Innodb or MyISAM
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Innodb or MyISAM
Where would you like to go today? http://antwrp.gsfc.nasa.gov/apod/
We have information about your home http://earthobservatory.nasa.gov/subscribe.php3
We have information about your home http://earthobservatory.nasa.gov/subscribe.php3
-
Prince of area51
- Registered User
- Posts: 133
- Joined: Mon Jun 27, 2005 8:46 pm
- Location: Manchester, UK
- Contact:
Re: Innodb or MyISAM
As far as I remember from ma Database lessons .. InnoDB are best suited for transaction-based tables (locking rows, etc). I think MyISAM will be a better choice as considering the number of users adding posts, we dont want tables to lock and create long back-logs (can't remember the exact term).