>Why are COM Components running in MTS so much slower than if you hard code the ADO script into an ASP page? I'm not just talking about FoxPro's Components. I have noticed the same thing with VB components, also. The speed of the asp code over the COM component in MTS is ten fold. Is this normal behavior or do I need take a look at my COM components?
Loading directly in the ASP page, the communication is from IIS to the COM object. The object will also remain in memory.
Running in MTS, the communication is from IIS to MTS to the COM object. The object will be released from memory if it isn't called in the specificed amount of time (3 minutes default if I recall). So, when it is needed again, it is again read from disk into memory.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer