|
|
|
|
|
Database logical design and
physical implementation
|
|
are always first priority,
but beyond our scope here.
|
|
Application partitioning
|
|
Work close to the data - actually inside the database is best
|
|
Stored procedures
|
|
many benefits where they are
applicable
|
|
language often painfully
limited compared with Perl
|
|
Moving data is expensive -bandwidth (bulk) and latency
(iterations)
|
|
Bulk-load - use proprietary tools for maximum speed
|
|
- you can use perl to massage the data into the right form
|
|
- bulk-load tools often have limited functionality
|
|
use DBI for maximum
flexibility, such as update-else-insert
|