Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 24 Oct 2001 16:50:40 -0500
From:      Joseph Koenig <joe@jwebmedia.com>
To:        questions@FreeBSD.ORG
Subject:   For Apache/PHP Gurus
Message-ID:  <3BD737AF.E66F6695@jwebmedia.com>

next in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3BD737AF.E66F6695>