Speed up connection time

From: Gustavo Badauy <gbadauy_at_my-deja.com>
Date: 2000/06/24
Message-ID: <8j2nom$1ab$1@nnrp1.deja.com>#1/1

Hi,

I have made a cgi that runs on the web server to connect to an Oracle 8.0 server to get some data out of the server and display it to the user. After some profiling on the code, I was able to conclude that it takes more time to connect to the erver than anything else. I was wondering if there is a way to speed up the connection process by doing a connection pooling or multiplexing, sort of what Microsoft does in ADO. If there is a way, what should I do? Do I need to make any changes on the code I wrote?

Any ideas are welcome.

PS: The program was written in C using OCI.

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jun 24 2000 - 00:00:00 CDT