So I'm starting development on a project with multiple components
which will
be talking to an Oracle 8 database, and I'm trying to understand what the
various options are.
The project will consist of HTML::Embperl pages, modperl CGIs, and random
Perl processes, all of which will connect to the database.
The questions I have mostly pertain to database connection caching. There
seem to be three different modules that all purport to cache the database
connection: DBI itself (using connect_cached), Apache::DBI, and
DBD::Proxy.
Apache::DBI caches the database handle, while connect_cached cache the
statement handle, so you could/should use both together. That's the way I
would go, but it doesn't will help you with your (non-mod_perl) cgi scripts.
If you want to speed them up, you need DBD::Proxy.
Gerald
---
Gerald Richter ecos electronic communication services gmbh
Internet - Infodatenbanken - Apache - Perl - mod_perl - Embperl
E-Mail: [EMAIL PROTECTED] Tel:+49-6133/925151
WWW:http://www.ecos.de Fax:+49-6133/925152
---