Slow performance using IIS7/FastCGI/MSSQL2012/Win2008R2

I am seeing extremely slow performance using a windows stack. Adding new relationships never seem to complete and with one user I can take the app down. Average page load is also in the 3 second range.

I have used the recommended settings for FastCGI and the performance with and without FastCGI is also the same.

Database is running fine as I see no queued queries at all.

Any help is appreciated.

Hi there,

I would consult your host if your CRM is running slow. What is the ‘Server response time’? SuiteCRM operates very well in most environments and response time is normally sub 1 second, unless you are loading the homepage from login or running advanced searches on large amounts of data.

Thanks,

Will.

Server response time is just fine; I am the only app running on this server and I have RDP’d into it without any issue and it’s on the local LAN.

I was creating the relationship which caused it to do a rebuild and I get the following error: Fatal error: Maximum execution time of 60 seconds exceeded in C:\SuiteCRM\ModuleInstall\ModuleInstaller.php on line 1804

It also looks like it started a rebuild and in that ModuleInstaller.php, it never got out of the function merge_files as it consistently timesout on that function.

I checked all the permissions and also gave EVERYONE god rights on the folder just to check it out, but that did not solve the problem. Looks like a setup issue. Same behavior in 7.1.2 and 7.1.3 MAX editions.