Re: The best way connecting.

From: Bali László <balizeg(at)freemail(dot)hu>
To: John DeSoi <desoi(at)pgedit(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: The best way connecting.
Date: 2006-05-31 17:32:46
Message-ID: 1149096767.14270.0.camel@laci.webalixnet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

OK, thnx.

2006. 05. 31, szerda keltezéssel 13.24-kor John DeSoi ezt írta:
> Should be no problem, a lot of systems work like this. Also see
> pgpool which can be used to minimize the overhead of opening and
> closing connections.
>
> http://pgpool.projects.postgresql.org/
>
>
>
>
> On May 31, 2006, at 11:36 AM, Bali László wrote:
>
> > I wanna make a web-based program.
> > The program stores the datas in a PG database. A lot of user can
> > be, and
> > the filling of data web forms could take 30 sec -1 min.
> > My idea is to handle the connection between the C program and the
> > database: using only ONE PGuser, and at the beginig of data inserting
> > process I make the connection and at the end of insertion I close the
> > connection, always.
> > What do you think? It is working? Can the PG handle the always
> > opening-closing situation, and a lot of transactions in one period
> > under
> > the name of one user ?
>
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-05-31 17:35:21 Re: A quick question on CONTRIB package
Previous Message John DeSoi 2006-05-31 17:24:18 Re: The best way connecting.