Solved

vb6 app still very slow

Posted on 2013-01-11
6
932 Views
Last Modified: 2013-01-11
Still trying to figure out why my vb6 app takes so much longer to process data on a remote server than a corresponding classic asp web page...

How often should I open a data connection with a connection string?  Currently I open it once as the page processes on my classic asp page but I open and close it every time I access data on my vb6 app.  Should I just open it and leave it open on the vb6 app?
0
Comment
Question by:Bob Schneider
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 47

Assisted Solution

by:Martin Liss
Martin Liss earned 334 total points
ID: 38769153
Should I just open it and leave it open on the vb6 app?
Sure, why not? Leave it open as long as you need it.
0
 

Author Comment

by:Bob Schneider
ID: 38769157
Ok so then do I declare the variable as a public variable in the main module?
0
 
LVL 27

Assisted Solution

by:Chris Luttrell
Chris Luttrell earned 166 total points
ID: 38769160
I am a database guy, not much .Net coding anymore, but you should be using some kind of framework that allows connection pooling and opens, shares and closes your connections as needed.  It is true that opening and closing the connection for every database is expensive, so a pool that is opened once or as needed that shares them is desirable.
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 
LVL 47

Accepted Solution

by:
Martin Liss earned 334 total points
ID: 38769176
Ok so then do I declare the variable as a public variable in the main module?
Yes.
0
 

Author Closing Comment

by:Bob Schneider
ID: 38769194
That was the problem.  Running well now!
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 38769246
I'm glad I was able to help.

Select the 'About Me' tab in my profile and you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2012
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question