Python + IIS/ASP questions (modules, namespaces, etc)

[Larry]

> > <snip>
> >
> > The only real state I need to persist across connections is the actual
> > database connection object, since these can be so expensive to obtain
> > (about 3 or 4 seconds in my tests.)
> 
> That seems slow, even for win32.  On my win2k server, Python can create
> literally hundreds of ADO connection objects (to an Access db!) in that much
> time.
>
I agree, something is amiss with your connection object, and it's not
something I'd try to persist. I open ADO connections to SQL Server on
a win2k server with Python/win32com and I've never had problems with
performance... and I often use the "implied connection" of opening ADO
recordsets with the connection string as a parameter so I do create
and drop a lot of connections.