[eml-dev] [Bug 2576] - Data Manager Library: Database Connection Pooling

[bugzilla-daemon@ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=2576


leinfelder at nceas.ucsb.edu changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |leinfelder at nceas.ucsb.edu




------- Comment #1 from leinfelder at nceas.ucsb.edu  2007-10-09 15:47 -------
As part of the work done on bug #2979, it came to light that there was a
significant bottleneck when hitting the database to look up entity/attribute
names to generate SQL queries.
An alternative to the
org.ecoinformatics.datamanager.database.DatabaseConnectionPoolInterfaceTest
implementation of DatabaseConnectionPoolInterface was created: the
org.ecoinformatics.datamanager.database.pooling.* classes along with [another]
properties file (pooling.properties).  The DatabaseConnectionPoolInterface
implementations (currently HSQL and Postgres) use the connection pooling
provided in their respective libraries and _dramatically_ enhanced performance
(~tenfold reduction).  A calling app would rely on the
DatabaseConnectionPoolInterfaceFactory (and correct settings in
pool.properties) to provide a DatabaseConnectionPoolInterface instance.
Feedback on this approach is appreciated as I'm not certain it meets all the
requirements originally specified in this bug.