First
Previous
Next
Last
Index
Text
Slide 28 of 54
Notes:
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
