Обсуждение: The best way connecting.
Hi, 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 ? Thanx in advance: Laci.
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
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 >