Brian, Try to always use a persistent connection. It improves performance, since there is no need to create a new PostgreSQL server process for each operation. It is even slower on some OS (guess what? :)).
There are some posts about it in PostgreSQL Performance List. Kind Regards. Daniel Cristian Em Qui, 2007-01-04 às 11:45 -0500, DEV escreveu: > Hello, > > I am working on an app in windows and things are going rather > well, thanks to many on this list. I currently have it setup where > any time you do anything with the database it makes a connection does > what is needed then closes the connection. I am wondering if I should > have the app coded to use a persistent connection where once you log > into the app your are connected and it stays connected and uses that > connection the whole time and closes it once you close the app or log > out. Your opinions are greatly appreciated! > > > > Brian Doyle > > > > > _______________________________________________ > Libpqxx-general mailing list > [email protected] > http://gborg.postgresql.org/mailman/listinfo/libpqxx-general -- Daniel Cristian Cruz クルズ クリスチアン ダニエル Analista de Sistemas Especialista Linux e PostgreSQL _______________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
