VB ActiveX DLL Performance Issues
Posted on 2003-02-20
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?