[Interest] Long running application with database connection

[S R]

In a similar situation, if I recall correctly, we elected to open the
database connection each time we needed it.  Through testing we found that
connection pooling in the the underlying infrastructure (windows, using
oracle and ms sqlserver) worked well.  The reconnection cost was usually
trivial compared with the actual query especially if the connection was
recently used; the resulting code was simpler/cleaner; and the approach
seemed robust to lots of other reasons (not just idle time) that the
connection might drop.  I do recall that it was hard to test well.

Sam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.qt-project.org/pipermail/interest/attachments/20131009/aed90bbe/attachment.html>