Thread: Question about connections

Question about connections

From
"Vitaly Shimansky"
Date:
If i have applet in HTML code that connects to PostgreSQL using JDBC(are there any other possibilities?), how many connections should i set in Pg configuration file? Because i can't know how many concurrent users(visitors) will be on my web page?
Thanks for answering!
Vitaly Shimansky
Riga, Latvia
 
 
P.S. If this address is not for that kind of questions please let me know.

Re: Question about connections

From
Dave Cramer
Date:
First, no there are no other possibilities.

second, assuming the applet requires a constant connection to the db,
then you need as many connections as you expect users.

if that assumption isn't correct and you can use pooling then probably
20 connections would be sufficient as long as you can keep their tasks
short, and return the connection quickly.

Dave
On Tue, 2004-05-25 at 05:15, Vitaly Shimansky wrote:
> If i have applet in HTML code that connects to PostgreSQL using
> JDBC(are there any other possibilities?), how many connections should
> i set in Pg configuration file? Because i can't know how many
> concurrent users(visitors) will be on my web page?
> Thanks for answering!
> Vitaly Shimansky
> Riga, Latvia
>
>
> P.S. If this address is not for that kind of questions please let me
> know.
> !DSPAM:40bbaab615671206916483!
--
Dave Cramer
519 939 0336
ICQ # 14675561