AdvancedPerlDBI.ppt

Advanced Perl DBI Making simple things easyand difficult things possible by Tim Bunce Topical Topics Speed Speed Speed! Handling handles and binding values Error checking and error handling Transactions Architecture and Tracing DBI for the web Bulk operations Tainting Handling LONG/BLOB data Portability Proxy power and flexible multiplex What’s planned Trimmed Topics and Tips Lack of time prevents the inclusion of ... Details of issues relating to specific databases and drivers (other than where used as examples of general issues) each driver would warrant a tutorial of its own! Non-trivial worked examples Handy DBIx::* and other DBI related modules … and anything I’d not finished implementing when this was written … But I hope you’ll agree that there’s ample information in the following 90+ slides… Tips for those attending the conference tutorial: Doodle notes from my whitterings about the ‘whys and wherefores’ on your printed copy of the slides as we go along... The DBI - What’s it all about? The Perl DBI defines and implements an interface to databases Plug-in driver modules do the database-specific work DBI provides default methods, functions, tools etc for drivers Not limited to the lowest common denominator The Perl DBI has built-in… Automatic error checking Detailed call tracing/debugging Flexible call profiling/benchmarking Designed and built for speed A picture is worth? Speed Speed Speed! What helps,what doesnt, and how to measure it Give me speed! DBI was designed for speed from day one DBI method dispatcher written in hand-crafted XS/C Dispatch to XS driver method calls is specially optimized Cached attributes returned directly by DBI dispatcher DBI overhead is generally insignificant So well talk about other speed issues instead ... Partition for speed Start at the beginning Pick the right database for the job, if you have the choice. Understand the performance issues in schema design. Application partitioning: Do What Where? Work close