Keep a handle on your databases
l Connecting to a database can be slow
l Try to connect once and stay connected where practical
n We'll discuss web server issues later
l New method:
n The new connect_cached() method acts like
prepare_cached() but for database handles
n It also checks the connection and reconnects if it's broken
n Similar, but not quite the same as Apache::DBI
n New and subject to change with experience
n Potentially most useful with DBD::Proxy & DBI::ProxyServer
35