Why is ActiveX EXE slower than ActiveX DLL?

[ckerrigan]

Hi,
I'm coverting an ActiveX DLL to an ActiveX EXE and the EXE is much slower especially with data transfer between 2 DAO recordsets.Any ideas?

[Keyser_Soze]

Hi,

When moving data between two EXE's, VB is having to Marshall the data across the process boundries. These boundries exist because each EXE runs in its own process (protected memory). When you have an EXE load up a DLL, the DLL is loaded into the same process as the EXE, so there are now bounderies (barring threads) so there is very little overhead in transfering data to and from the EXE and DLL. This Marshalling is a huge performance hit in transfering data.