| Database Design |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | HEAP
Tables |
|||||||||||||
| – | Stored
in memory |
|||||||||||||
| • | They will
vanish at server shutdown |
|||||||||||||
| – | Very
fast hash-based lookups |
|||||||||||||
| • | Limited
index use |
|||||||||||||
| • | Range
queries are slower |
|||||||||||||
| – | Table
locking |
|||||||||||||
| – | Great
for static lookups |
|||||||||||||
| – | Size
can be limited to prevent disaster |
|||||||||||||
| Copyright
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |