aamir11
asked on
VB ActiveX DLL Performance Issues
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Do you have access to MTS (Microsoft Transaction Service?)
Dabas
Dabas
ASKER
Yes, could that be an issue?
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
ASKER
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?
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
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
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?
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?
ASKER
Can I get my points refunded?
aamir11,
If you want to delete this question, post a zero-point question in https://www.experts-exchange.com/Community_Support/
Subject: Moderator Please Delete
Body: Please delete this question:
https://www.experts-exchange.com/questions/20523073/VB-ActiveX-DLL-Performance-Issues.html
Dabas
If you want to delete this question, post a zero-point question in https://www.experts-exchange.com/Community_Support/
Subject: Moderator Please Delete
Body: Please delete this question:
https://www.experts-exchange.com/questions/20523073/VB-ActiveX-DLL-Performance-Issues.html
Dabas
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.
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.
ASKER