| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | balizeg(at)freemail(dot)hu |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: The best way connecting. |
| Date: | 2006-05-31 17:24:18 |
| Message-ID: | AC61F51A-62AC-456A-8CA7-10DDFA2D3486@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bali László | 2006-05-31 17:32:46 | Re: The best way connecting. |
| Previous Message | Joshua D. Drake | 2006-05-31 16:56:52 | Re: SCSI disk: still the way to go? |