[Libpqxx-general] Is it better to keep the connection or to open, use and close it?

[Matheus Araújo Aguiar]

Hi folks,

I'm using libpqxx through a c++ class i've coded called db_interface. This
class abstracts several queries i have to make in my program. Right now i'm
wondering what would be the best way of handling the connection with the
database. So would it be better to open the connection once, and use it
through the lifetime of the object or just open the connection, make the
requested transactions and close it ?

Thanx in advance!

-- 
Matheus Araújo Aguiar
Computer Scientist
matheus.pit at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/libpqxx-general/attachments/20090817/43329ad4/attachment.html>