| Database
Design |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Select the right table types |
||||||||||||||
| – | What locking model do you need? |
||||||||||||||
| • | Table (MyISAM) |
||||||||||||||
| • | Row (InnoDB) |
||||||||||||||
| • | Page
(BDB) |
||||||||||||||
| – | Consider ratio of reads to writes |
||||||||||||||
| – | Foreign key constraints? |
||||||||||||||
| – | Do you need transactions? |
||||||||||||||
| – | Can you afford to lose records in a crash? |
||||||||||||||
| – | Do you know MySQL’s table types? |
||||||||||||||
| Copyright 2003, Jeremy Zawodny |