Global ODBC Connect/Disconnect

HCL Domino Domino Forum
1

I have an app which makes many script calls to Oralce in any one session via ODBC from the client side. Response times can range from a couple of seconds to several seconds - 15 seconds has been known. Each function (button/agent etc.) does a Connect, Execute, Disconnect.

I have been asked to investigate the possibility of doing 1 global connect on database open, then every piece of code only reconnects if the connection is not available, and a global disconnect when the database is closed. Any thoughts/comments on this approach - is it even possible?

Thanks.

2

Subject: Global ODBC Connect/Disconnect

it may be easier to configure the ODBC driver to use connection pooling… see http://docs.openlinksw.com/mt/oraconcpoolgeneric.html

3

Subject: Global ODBC Connect/Disconnect

It appears your using LC LSX to make your calls based on the methods mentioned.

If using LC LSX look up ‘Connection Pooling’ in the help DB for a good description

To set it use: LCSession.ConnectionPooling = true