[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    Re: Apache::DB install?
From:       Jim Cromie <jcromie () divsol ! com>
Date:       2003-08-14 4:26:48
[Download RAW message or body]

Xu, Qiang (XSSC SGP) wrote:

>
> Any difference between
>Apache-DBI and DBI? 
>
>  
>
quite a bit, and none at all.

key to Apache-DBI is that when used in mod-perl, it works like a cache of
open DBI handles; when your cgi script runs and calls DBI->connect(@args),
it is given a reference to a previously opened and cached handle, or if 
the connect @args
are different, opens a new one for you, and saves it to cache, assuming 
youll be back
to use it again.

I believe your code can remain unchanged; you call DBI->connect,
not Apache::DBI->connect.   But you do have to load Apache::DBI at
server startup (either directly or indirectly from a <Perl> section in 
your httpd.conf

I dunno whether it eventually closes LRU handles, or whether/how-many 
additional
handles it will open if the currently available matches are busy, but im 
sure some hints
are in the docs.

and caveats apply - im writing from memory /understanding, not from perldoc

>thanks, 
>
>Regards,
>Xu Qiang
>
>
>  
>



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=msql-mysql-modules@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]