Guest User

Untitled

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