Persistant DB Connections

Jigsaw Team,
    First thanks for all the great work!. Looks like I have found a
very flexable base from which to construct the system I am currently
designing. That system is basically an intranet query and analysis
system fed by serveral corporate db's.

After much experimentation with SSI, Servlets, etc, the dynamic
generation looks pretty straight forward. However, the key issue
I have now is performance. Specifically, I want to avoid the overhead
on each db server of making a db connection each time a page is
generated.


I would like to establish ODBC connections to each seperate
db server with one class and have it "broker" the queries and
deliver responses back to the calling resource, SSI, or Servlet.

I would like this connection to be persistant from server startup
through shutdown, with the necessary logic to re-establish
connection(s) if needed,  accessable via an  interface that can be used
by either an ssi command, servlet, or custom resource.

What is your vision for this level of functionality ?
Would a seperate "thin" or dedicated connection manager
or server be a easier path than adding this functionality to
Jigsaw.

Any thoughts, references, etc on this matter would be
greatly appreciated.

Thanks in advance,

Paul Walker
Dell Computer Corp.

Received on Thursday, 11 December 1997 22:26:34 UTC