Comments on: VB app connecting to Oracle databasehttp://itknowledgeexchange.techtarget.com/itanswers/vb-app-connecting-to-oracle-database/
Tue, 31 Mar 2015 21:33:46 +0000hourly1By: VB app connecting to Oracle database (Q/A) | Seek The Sun Slowlyhttp://itknowledgeexchange.techtarget.com/itanswers/vb-app-connecting-to-oracle-database/#comment-108166
Fri, 08 Jun 2012 07:13:37 +0000#comment-108166[…] Address: http://itknowledgeexchange.techtarget.com/itanswers/vb-app-connecting-to-oracle-database/ (0) Comments Read […]
]]>By: gchererhttp://itknowledgeexchange.techtarget.com/itanswers/vb-app-connecting-to-oracle-database/#comment-48653
Tue, 22 Nov 2005 17:10:09 +0000#comment-48653Often, the main controllable drag in this scenario is the dispatcher’s allocation of stubs to handle the task. Pre-allocated stubs saves some effort at the expense of some memory. Try MTS or consider a another tier between the client and server. The new tier would keep a few more or less constant logins, but keep track of which client is doing what. Using the new security facilities in 9i makes this very slick. In your case, the actual number of clients and transactions makes it hard to cost-justify far-sighted solutions. But, you would know whether your environment is growing or staying static. g’luck.
]]>By: skovachttp://itknowledgeexchange.techtarget.com/itanswers/vb-app-connecting-to-oracle-database/#comment-48654
Thu, 03 Nov 2005 14:12:30 +0000#comment-48654Thanks for yout thoughts. What prompted this was the following chunck from my statspack report. I searched for mathing sql and found out that it something that happens every time VB makes a connection.

]]>By: sheldonlinkerhttp://itknowledgeexchange.techtarget.com/itanswers/vb-app-connecting-to-oracle-database/#comment-48655
Wed, 02 Nov 2005 13:40:31 +0000#comment-48655Leaving a connection open “costs” virtually nothing, in terms of system resources. Closing a connection is “cheap”, too. Establishing a connection is time-consuming. Best to leave the connection open.