http://www.perlmonks.org?node_id=125090


in reply to Tricks with DBI

Great article - however: And, for the same reasons, you should use prepare_cached instead of prepare.

Don't use prepare_cached() with DBD::Sybase - this would open multiple connections to your server (one for each cached statement handle). If you have a need to have a few requests that you are going to call a *lot* you may want to create stored procedures for them instead.

Michael