Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- innodb (rbdms) vs. myisam (toy rdbms)
- --------------------------------------
- 1. row locks vs. table locks - think concurrency, many user accessing the system at the same time
- 2. transactions (ACID compliant) vs. no transactions - think omg where is my data, why is my table corrupt
- 3. clustered indexes (clustered btree) vs. btree (non clustered) - think why does it take me 2 mins to query 10 million rows
- 4. oracle bought innodb vs. oracle laughed at myisam - myisam is like dbase III from Ashton Tate - it's like 100 years old.
- 5.
- 6.
- 7.
Add Comment
Please, Sign In to add comment