On Sunday, June 3, 2001, at 12:28  pm, Clayton Cottingham aka drfrog 
wrote:
>
> heres what im caught on :
> 1.is it best to load Apache::DBI at start up of apache and can i load 
> more than
> one connection type?

yes via PerlModule or a PerlRequire for a startup.pl. My understanding 
is that forked children will get a copy of the pre-loaded module, rather 
than having to load it afresh. This will save you each http child 
loading the module when it is first used.

re connection types, these are usually pulled in with a startup.pl line 
something like

$dbh = Apache::DBI->connect_on_init("$driver", "$user", "$pwd");

AFAIK, Apache::DBI performs connection caching based on a hash of the 
connection parameters,
so next time Apache sees a connect with the same $driver/$user/$pwd 
combo, it will hand out a pre-opened connection, if it has one. If you 
open a connection for a different user/pwd connection, Apache::DBI will 
open a new connection.

To get this other connection pre-opened, just add

$dbh2 = Apache::DBI->connect_on_init("$driver2", "$user2", "$pwd2");

to your startup.pl

I haven't used Apache::Session, so I can't help you with the rest ...

    cheers,
          Martin

> 2.is it best to login and then set session or set session and then log 
> in
> 3. what about 'last session' type storage
> 4. if Apache::DBI is on at startup how can i load a specific connection 
> type
> for Sessions?
>
> i think that's all  the really big questions i have
>
>
> system info
> mandrake 7.2 with Apache1.3.12, modperl 1.,& postgres 7.1
> 700Mhz 312 mb ram
>
>
>
>

Reply via email to