Session pooling

[hsteigstra]

In our cgi-bin application we would like to take advantage of the session pooling fascility of the TOracleSession component. The idea is now to create a simple server application that creates a set of TOracleSessions. The cgi-bin application then should fetch a session from this pool and open the session by setting the ExternalLDA/SVC property.
Question: how do I retrieve the value of this property from the server application and how to parse the value of this pointer to the cgi-bin module? Use SendMessage?

Thanks, Herman Steigstra

 

[Marco Kalter]

This won't work, the session pool can only be used directly from within a single program. The only alternative is a 3 tier solution, where the server application on the middle tier pools the sessions, and the cgi program communicates with the server application without directly using a session.

 

[hsteigstra]

Does that mean that when I use the Oracle Session Pooling (spMTS) that it will not work either? I experimented with the spInternal setting as I don't have to install anything on the Oracle side for that....

I already have been experimenting with 3-Tier concepts, but that does not work as the cgi-bin application is already part of a 3-tier solution, making it a 5-tier application.

You mentioned in another thread that putting the application on the database server will speed up connection time.
I now have connection times of 0.15 sec. Will that improve much ???

 

[Marco Kalter]

Using MTS will indeed help, just like a 3-tier solution.

The connection time improvement for a local connection vs a remote connection should be considerable. It depends on your configuration, but the connection time may be as little as a few hundreths of a second. If I try a local connection here, it is about 0.03 seconds.

 

[hsteigstra]

I have an Oracle server running on my development PC (2Ghz) and don't see any difference in login time compared to the main Oracle Server (1.4 Ghz) both are 125 msec.

At this moment we are running Oracle 8.1.7 As I understand Oracle 9.2 has a built in session pooling. If we would migrate to Oracle 9.2, can we then use the setting spMTS or should it be spNone.

 

[Marco Kalter]

There is no real difference between Oracle9.2 session pooling and Direct Oracle Access internal session pooling. You will still run into the limitation that the pool is maintained by the host application. As soon as the application stops, the pool is gone.

 

[hsteigstra]

I have been checking connection speed and some interesting numbers appeared:
* Local or remote does not make any difference
* OCI7 is 30% faster
* Processor speed of the client is the most important factor
* connecting from one Oracle database server to another is twice as fast, despite the lower speed (50 msec at 1.4 Ghz server vs. 100 msec at 2.4 Ghz workstation)

Just one question. Any idea why a server connects faster (to another server!) then a work station??

 

[Marco Kalter]

For the first connection the Oracle Net library (oci.dll) and dependant libraries need to be loaded. It may be that the file system on the server is faster, or that Windows has already got the oci.dll in memory.