 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Application Design
|
|
|
|
|
Use the right column types
|
|
|
|
|
Use the right table types
|
|
|
|
|
Concurrency/Locking
|
|
|
|
|
Features: full-text, foreign keys, etc.
|
|
|
|
|
Cache infrequently changed data
|
|
|
|
|
Or use HEAP (in-memory) tables
|
|
|
|
|
Dont over-use sessions
|
|
|
|
|
Plan for growth, possibly using replication
|
|
|
|
Use transactions where they make sense
|
|