Re: Apache::DBI persistent connections

From: Rudy Lippan (rlippan_at_remotelinux.com)
Date: 05/20/04

  • Next message: Tim Bunce: "Re: need to pull multi-byte out of a varchar2 field" 
    Date: Thu, 20 May 2004 16:26:44 -0400 (EDT)
To: Keith Jackson <kjackson@eyemg.com>

    On 20 May 2004, Keith Jackson wrote:

    > Why is there another connection each time I reload the page? Any help
    > would be appreciated.

    Because you have more than 1 apache process. Each httpd process can cache a
    connexion handle to each of the databases that it uses.

    So if you have Max Clients set to 150 mod perl can have 150 connexions open
    times the number of databases used by your various applications. eg. 4
    applications (each using a different db) and 150 Max clients = up to 600 db
    connexions.

    Of course all of the above assumes that I am remember things correctly :)

    Rudy

  • Next message: Tim Bunce: "Re: need to pull multi-byte out of a varchar2 field"