Click to See Complete Forum and Search --> : ActiveX exe so sloooowwww!!
rathtap
Aug 14th, 2001, 09:05 AM
I took some class modules from my standard exe and converted them into an ActiveX exe. It works as it should, except that it takes twice as long to process the data. It is not marshalling that is causing it, because there is no data being sent to or from the client and the COM object. Moreover, they are even on the same machine! There is heavy ADO usage on an Access database which is also on the same machine( but that is how it was earlier too).
What could be causing my app to slow down so much??
rathtap
Aug 14th, 2001, 12:32 PM
I changed the ActixeX EXE to a DLL but am still not seeing any difference in speed. So the reason is obviously nothing to do with memory space.
Any ideas folks!! Might the threading model have anything to do? I do not think so because my app is the only one using it.
Swissa
Aug 15th, 2001, 05:00 AM
When a request come from the Client App to the COM object ,Do you initiate the Connection to the Database everytime .....or your connection is always up and your are using a connector class to share the connection ???
rathtap
Aug 15th, 2001, 07:42 AM
The connection is created when the request comes. I can see where you are going and I will see if creating a connecter class makes any difference. However it is not that the request is coming every so often. In one session the client may request the COM object just once. So I am in fact creating just one connection from the COM object.
rathtap
Aug 15th, 2001, 10:34 AM
Swissa,
I am having a tough time creating the connector class. Would you happen to have any code that could help? Muchas gracias!!
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.