•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 361,914 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,571 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
| View Poll Results: innodb or myisam ? | |||
| innodb |    | 1 | 50.00% |
| myisam |    | 1 | 50.00% |
| Voters: 2. You may not vote on this poll | |||
Views: 16468 | Replies: 2
 |
•
•
Join Date: Sep 2004
Posts: 33
Reputation: 
Rep Power: 4
Solved Threads: 0
Light Poster
innodb vs myisam 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.
thanx u all.
•
•
Join Date: Feb 2002
Location: Lawn Guylen, NY
Posts: 10,866
Reputation:
Rep Power: 32
Solved Threads: 107
This thread should answer your question: http://www.daniweb.com/techtalkforums/thread40911.html
Dani the Computer Science Gal
Do you run a computer-related website? Feature it in our niche link directory!
Do you run a computer-related website? Feature it in our niche link directory!
•
•
Join Date: May 2006
Location: nyc
Posts: 16
Reputation:
Rep Power: 3
Solved Threads: 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.
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- MyISAM vs InnoDB (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: URGENT: Implementing search with multiple dissimilar MySQL tables
- Next Thread: Please help integrate website and database!
