Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

VB ActiveX DLL Performance Issues

Posted on 2003-02-20
12
Medium Priority
?
196 Views
Last Modified: 2010-05-01
Hi,

I'm currently working on a system which uses ASP's to access a MS Access Database.  The middle business logic layer is done with a Visual Basic ActiveX DLL that was created in VB 6.0.  So visually, the ASP relies on the DLL to pull values and calculate them from the DB, a common development approach.

     ASP <-- DLL <-- DB

The issue is that as the size of the database increases, the performance for the system slows down considerably for the function and method calls to the DLL.  However when these same function and method calls are made in the VB IDE before the DLL is compiled, the performance is not bad.  

An example, I use a method called getMeasuresByOwner and I pass in an owner ID.  If I execute that from the ASP by creating an object from the dll, it takes about 17 seconds.  However if I call that same method from a form before compiling the DLL, it takes me only 6 seconds.  

Is there any reason why the performance should suffer so much?

Thanks.
0
Comment
Question by:aamir11
  • 5
  • 5
  • 2
12 Comments
 
LVL 27

Accepted Solution

by:
Dabas earned 400 total points
ID: 7991144
The main question here is how you are accessing the DB.

When you do so on the IDE, is it on the same computer?

When in your compiled application, is it on the same computer?

Even if it is on the same computer, do you access it directly or through a network path (is it c:\... or \\computer_name\... ) If the latter, then the reading of the data is still going through the network, and can slow you down

Dabas
0
 
LVL 1

Author Comment

by:aamir11
ID: 7993589
Both times I access it, it is through the network.  I understand that hardware differences might cause this as well, but I was hoping to see if there were any issues with how I compile the DLL or how I register and call the DLL that might affect performance.
0
 
LVL 1

Author Comment

by:aamir11
ID: 7993679
Both times I access it, it is through the network.  I understand that hardware differences might cause this as well, but I was hoping to see if there were any issues with how I compile the DLL or how I register and call the DLL that might affect performance.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 27

Expert Comment

by:Dabas
ID: 7996350
Do you have access to MTS (Microsoft Transaction Service?)

Dabas
0
 
LVL 1

Author Comment

by:aamir11
ID: 8009033
Yes, could that be an issue?
0
 
LVL 27

Expert Comment

by:Dabas
ID: 8010724
It is not, but if you register your dlls on MTS and use them in a client - server type of solution it may be the end to your problem
0
 
LVL 1

Author Comment

by:aamir11
ID: 8328437
Apparently the time required to load the DLL into memory was slowing performanace down considerably.   To get a slight performance increase I recompiled in VB with the "Option Explicit" tag and selected the option "Retained in Memory".  I guess this question is done?
0
 
LVL 27

Expert Comment

by:Dabas
ID: 8329040
aamir11:

You can post a comment in the Cleanup section of Community support asking for a refund of your points.

Alternatively, you can choose one of my answers (since there was nobody else active) and assign it a grade of A, B or C

Dabas
0
 

Expert Comment

by:CleanupPing
ID: 8901348
aamir11:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
0
 
LVL 1

Author Comment

by:aamir11
ID: 8902361
Can I get my points refunded?
0
 
LVL 27

Expert Comment

by:Dabas
ID: 8906195
aamir11,
If you want to delete this question, post a zero-point question in http://www.experts-exchange.com/Community_Support/

Subject: Moderator Please Delete
Body: Please delete this question:
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20523073.html


Dabas
0
 

Expert Comment

by:CleanupPing
ID: 9056647
aamir11:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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

571 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