whats the difference between a table created in innodb and one created in myisam?'Advantages/disadvantage of innodb over myisam and which will you recommend on a web based application specifically meant for dating?
thanx u all.
anthmaina 0 Light Poster
Recommended Answers
Jump to PostThis thread should answer your question: http://www.daniweb.com/techtalkforums/thread40911.html
All 3 Replies
Dani 4,675 The Queen of DaniWeb Administrator Featured Poster Premium Member
acescence 0 Newbie Poster
in my experience, myisam is better for high read volumes, innodb for high update volumes due to table vs row locking.
innodb is journaled, and can recover from crashes where myisam can't, much like NTFS vs FAT file systems.
myisam has full-text indexing, innodb doesn't.
innodb has transaction support, commits and rollbacks, myisam lacks these.
sen1989 0 Newbie Poster
Myisam is default database engine It's not supported in transction.
But Innodb supported all transactions.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.