Hi,
I have just started on DNA architecture. I have written a com dll (say XDLL) in VB. This inturn calls ADO to make a database connection. The XDLL has one function which takes two parameters. The function checks a table of two columns and returns TRUE or FALSE.
I call this dll in ASP page. Works fine.
Here is the problem, though :
If i write the ASP (pseudo)code like this-
for i = 1 to 500
CreateObjext XDLL
Call the method of XDLL
Set the Obj to NOTHING
NEXT
the dllhost grows to 50MB. If the machine is left idle for 10 seconds the dllhost dies.But instead if the same page is called again, the dllhost grows from 50 to 100MB and this goes on.(this happens if i call the page from different machines as well). In WEB scenario where somebody may be always connected, dllhost would keep growing and ultimately m/c would crash. What is the solution ?
I am using Windows 2000 server.
If i deploy the com dlls in MTS will MTS act as surrogate and the problem will be solved ?
Thanx for all your help.

:-) Parshwanath