?
Solved

vb6 app still very slow

Posted on 2013-01-11
6
Medium Priority
?
940 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 49

Assisted Solution

by:Martin Liss
Martin Liss earned 1336 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 664 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
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
LVL 49

Accepted Solution

by:
Martin Liss earned 1336 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 49

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

752 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