Re: [Proxool-developer] Proxool Alive?

[Bill H. <bi...@lo...>]

Hi Glen,

I'm glad Proxool is working well for you.

I guess the proxool-user list is the best place for advice about
maximum-connection-count, but since you're here... I'd choose a number such
that:

1. Your database can cope with the load. There's no point having 4,000
connections if each simple query is going to take several seconds.

2. Your app can take the load too. Even if the database is fantastic and can
execute whatever you can throw at it with ease, your app has still got to
cope too.

That second reason is partly why we made Proxool reject connections when we
reached the maximum. We figured that by the time we'd used them all up our
app was struggling to keep up and all we wanted to do was quickly respond
with a "please try later" message. Otherwise everything ground to a halt.

Cheers,
-- 
Bill Horsman
http://www.logicalcobwebs.com/bill_horsman