| Database Design |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Select
the right table types |
||||||||||||||
| – | What
locking model do you need? |
||||||||||||||
| • | Table |
||||||||||||||
| • | Row |
||||||||||||||
| • | Page |
||||||||||||||
| – | 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
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |