From owner-freebsd-questions Wed Oct 24 14:44: 7 2001 Delivered-To: freebsd-questions@freebsd.org Received: from email.accessus.net (email.accessus.net [209.145.128.5]) by hub.freebsd.org (Postfix) with ESMTP id 1BC8737B403 for ; Wed, 24 Oct 2001 14:44:03 -0700 (PDT) Received: from [209.145.133.59] (account jkoenig@accessus.net HELO jwebmedia.com) by email.accessus.net (CommuniGate Pro SMTP 3.4.8) with ESMTP id 24274260 for questions@FreeBSD.ORG; Wed, 24 Oct 2001 16:44:02 -0500 Message-ID: <3BD737AF.E66F6695@jwebmedia.com> Date: Wed, 24 Oct 2001 16:50:40 -0500 From: Joseph Koenig Reply-To: joe@jwebmedia.com Organization: jWeb New Media Design X-Mailer: Mozilla 4.77 (Macintosh; U; PPC) X-Accept-Language: en MIME-Version: 1.0 To: questions@FreeBSD.ORG Subject: For Apache/PHP Gurus Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG What effect do the following have, in relation to persistent database connections opened: 1) Limiting the number of servers apache starts in the httpd.conf file (let's say we set it to 2) 2) Limiting the odbc_max_persistent in the php.ini file (let's say, again, 2) I have a client that has a Progress DB on a WinNT server, while his site is hosted in FreeBSD 4.3. He has software so he can open 2 ODBC connections at a time. This is an e-comm site, so I highly doubt 2 connections is enough, but I'm not familiar enough with how persistent connections work. I read up on them at the php.net site, and it helped a bit, but not completely. Say we leave apache at StartServers = 10, but limit the odbc_max_persistent connections to '2'. Will the site barf if those two connections are opened and someone makes a request off the 3rd server. From what I understand, it should re-use on of the open connections. If that connection is in use, will PHP/Apache wait for the connection to open, then use it, or will it just come back and say it can't connect? I did ask this question to the PHP list and didn't get any real response. That means it went over some heads (doubt) or it's a really aweful question. Can someone please help me out? Thanks a ton, Joe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message