 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| l |
Application
partitioning
|
|
|
|
– |
stop and think -
work smarter not harder
|
|
|
|
n |
Pick the right
database for the job, if you have the choice
|
|
|
n |
Work close to the
data
|
|
|
|
n |
Use stored
procedures where appropriate
|
|
|
|
n |
Moving data
to/from the client is always expensive
|
|
|
|
– |
think of latency
as well as bandwidth
|
|
|
|
n |
Use proprietary
bulk-load where appropriate
|
|
|
|
n |
Consider
database maths vs. Perl maths
|
|
|
|
n |
Multiple simple
queries with 'joins' in Perl may be faster
|
|
|
|
n |
Consider local
caching, in memory or DBM file etc.
|
|
|
|
n |
Mix 'n Match
techniques as needed
|
|