Problem:

Release: 3.1

How to improve the performance of COM objects.

Resolution:

Check the following:

1) The COBOL programs should be compiled with the following directives:

   SQL(THREAD=ISOLATE)

   REENTRANT(2)

   and be using appartment threading.

2) OpenESQL uses dynamic and lock cursors by default.  For most applications this

   is overkill.  Immediately after conneting they should execute:

   exec sql set concurrency read only end-exec.

   exec sql set scrolloption forward end-exec.

3) It is probably worth experimenting with connection pooling.  There are two

   options:

   SQL(CONNECTIONPOOL=DRIVER) or

   SQL(CONNECTIONPOOL=ENVIRONMENT)

   This may improve performance although experiments have had mixed results. Connection pooling can make a dramatic difference to performance.  However, the results seem to depend on the operating system and ODBC Driver Manager versions.