I have a PHP 4.3.10 app running under IIS 5.1 connecting to a Win2K3 SQLServer box using MSSQL functions. For the most part, response time is adequate, however, I have some really data retrieval intensive functions for forecasting that when invoked run VERY slow. The same code performs real fast against MySQL, but I need to optimize this for MSSQL.
I've tried numerous suggestions from other posts such as putting in HOST entries to the DB server, swithing from CGI to ISAPI. My forecasting algorithims are stable and optimized as best as possible.
I'm hearing that ADO calls rather than MSSQL could be faster, but how much faster?
Any help is appreciated.
