That was a flamebait!
PHP shares connections to the DB as well you know :P
If you specify two connections to two different databases but using the
same username/password then a previously opened connection can be used
again. The main reason I have 200 concurrent connections open is because
there's a stream of data going to the clients all the time. I tried
opening up connections ever few seconds, but even with a delay of 10
seconds the lag killed any "realtime" aspect of the data. :(
I would dearly love to use AOLserver but even the PHP developers say PHP
hasn't been tested well enough in threaded environments. I offered to
test it but I never got around to it last weekend, this weekendis going
to be pretty busy too. oops!
Donncha.
"John P. Looney (Kate)" wrote:
>> On Tue, Jun 13, 2000 at 04:30:18PM +0100, Donncha O Caoimh mentioned:
> > heh.. working on a streaming app at the moment, started out, had 800
> > connections to MySQL on two machines (600 to one, 200 to the other) for
> > 200 conncurrent users. Managed to cut it down to 200 connections to the
> > local server and occasional connections to the other server if need be..
> > woo :)
> > Ever see load average reach 150? it's possible, and beyond!
>> Which is why *real* websites use AOLserver, and the fact that it only
> opens 8 connections, and has just *one* process, whose hundreds of threads
> share those connections... ;)
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
