Oninit cdi / Archive
Talk to an expert →

DB Disconnect/Reconnect

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET

jwz1@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

I have a VB app that uses DAO and ODBC to connect to an Informix DB on a SCO-UNIX server. The initial connection takes approximately 15 seconds. Once connected, the response is adequate. However, if a user has the app running, but doesn't use the VB app for some number of minutes, maybe 10 to 15, and then performs an operation that requires data from the DB, the app is very slow to retrieve the data. It seems to be reconnecting to the Informix DB, again. Once this first data is retrieved, subsequent reads to the DB are fast. Is the app disconnecting from the DB after a period of inactivity? Is there a parameter that I can set to eliminate this disconnection? Has anybody seen and fixed this problem? Thanks for the help. Joel Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to jwz1@my-deja.com
Watawinona — — source: Informix-list mailing list archive (1991-1998)

DAO does additional connections for each statement. Thus, you end up killing the backend with connection requests. Microsoft has been preaching for at least 4 or 5 years that you should use RDO or ADO instead of DAO. Consider moving the application to JDK applets and connect to the server with JDBC. Nona >Subject: DB Disconnect/Reconnect >From: jwz1@my-deja.com >Date: 16.03.00 15:35 W. Europe Standard Time >Message-id: <8aqres$kab$1@nnrp1.deja.com> > >I have a VB app that uses DAO and ODBC to connect to an Informix DB on >a SCO-UNIX server. The initial connection takes approximately 15 >seconds. Once connected, the response is adequate. However, if a user >has the app running, but doesn't use the VB app for some number of >minutes, maybe 10 to 15, and then performs an operation that requires >data from the DB, the app is very slow to retrieve the data. It seems >to be reconnecting to the Informix DB, again. Once this first data is >retrieved, subsequent reads to the DB are fast. > >Is the app disconnecting from the DB after a period of inactivity? Is >there a parameter that I can set to eliminate this disconnection? Has >anybody seen and fixed this problem? > >Thanks for the help. > >Joel > > >Sent via Deja.com http://www.deja.com/ >Before you buy. > >