Re: Question about connections

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Vitaly Shimansky <desert_illusion(at)optiline(dot)lv>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Question about connections
Date: 2004-06-01 03:07:47
Message-ID: 1086059267.1585.9.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-06-01 03:13:00 Re: Arrays and JDBC :: setObject causes array_in Need to
Previous Message Oliver Jowett 2004-06-01 00:38:42 Re: Postgresql 7.4.2 and OutOfMemoryError