I have loaded 2 Django apps on IIS using isapi-wsgi.
These are both server setups:
Windows Server 2003, IIS6 and SQL Server 2005
Windows Server 2008 R2, IIS7.5 and SQL Server 2008
The Django apps are completely different from each other.
They both take random periods of time for each requests between 1 and 10 seconds.
This is painfully slow compared to 100ms-500ms of an Apache+mod_wsgi setup, so there must be something wrong.
Any ideas? Would really be great if I could fix this. :)
Solved!
Do not use django-mssql use django-pyodbc instead!!
Install another web server, like apache.
Seriously - IIS sucks on running python wsgi apps. There's not much you can do in that regard.