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.
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.
Jump to PostThis thread should answer your question: http://www.daniweb.com/techtalkforums/thread40911.html
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.
Myisam is default database engine It's not supported in transction.
But Innodb supported all transactions.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.
You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed. It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post.