Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:27870 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 23151 invoked by uid 1010); 7 Feb 2007 04:36:58 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 23135 invoked from network); 7 Feb 2007 04:36:58 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 7 Feb 2007 04:36:58 -0000 Authentication-Results: pb1.pair.com header.from=christopher.jones@oracle.com; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=christopher.jones@oracle.com; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain oracle.com from 148.87.113.118 cause and error) X-PHP-List-Original-Sender: christopher.jones@oracle.com X-Host-Fingerprint: 148.87.113.118 rgminet01.oracle.com Linux 2.4/2.6 Received: from [148.87.113.118] ([148.87.113.118:44265] helo=rgminet01.oracle.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 34/43-18288-96759C54 for ; Tue, 06 Feb 2007 23:36:57 -0500 Received: from rgmsgw01.us.oracle.com (rgmsgw01.us.oracle.com [138.1.186.51]) by rgminet01.oracle.com (Switch-3.2.4/Switch-3.1.6) with ESMTP id l174arWg027233; Tue, 6 Feb 2007 21:36:53 -0700 Received: from [141.144.82.75] (dhcp-amer-whq-csvpn-gw3-141-144-82-75.vpn.oracle.com [141.144.82.75]) by rgmsgw01.us.oracle.com (Switch-3.2.4/Switch-3.2.4) with ESMTP id l174apOm028700 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 6 Feb 2007 21:36:52 -0700 Message-ID: <45C95757.9070809@oracle.com> Date: Tue, 06 Feb 2007 20:36:39 -0800 Organization: Oracle Corporation User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: steve CC: internals@lists.php.net References: <57792e850702061922k4fcc1456s80925516ed8d7fee@mail.gmail.com> In-Reply-To: <57792e850702061922k4fcc1456s80925516ed8d7fee@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Brightmail-Tracker: AAAAAQAAAAI= X-Brightmail-Tracker: AAAAAQAAAAI= X-Whitelist: TRUE X-Whitelist: TRUE Subject: Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli From: christopher.jones@oracle.com (Christopher Jones) steve wrote: > Oh, and allow persistent connections in db apis again (like mysqli). It might happen. Wez Furlong was contemplating a persistent connection implementation for the generic PDO interface following on from the persistent connection model in the oci8 extension for Oracle. > As an example, lets suppose an example with 2000 connections, using > keep-alive, with 20 connections downloading static content and 50 > downloading dynamic (PHP) content. In Apache 1.3, you would have to > accommodate 2000 processes (either changing the hard limit, or using > multiple servers). If you used persistent connections that would be > 2000 (almost all idle) connections to mysql. (In the real world this > is why you would either disable persistent connections or keep-alive, > and most likely both.) The oci8 extension lets you timeout idle persistent connections. Unrelated to your FastCGI suggestion but FYI on database connection pooling: http://blogs.oracle.com/opal/2007/01/03. The pooling described has no dependency on how you deploy your application and works across multiple application types connecting to the DB. Chris -- Christopher Jones, Oracle Email: Christopher.Jones@oracle.com Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/