New PHP website

[stebo730]

We have had a new website developed for us and are in the process of setting it up.

 

It is a PHP based site with MySQL running on a Windows 2008 R2 Server with IIS.

 

Although the website works and can be accessed it is very very very slow to load each page. My thoughts are that it is have trouple connecting efficiently to MySQL however I have very little experience in troubleshooting these issues. The Web Development company we are using are out of ideas.

 

Any advice on this would be greatly appreciated - I can PM you the link to the site if needed.

[rush_tech]

are you able to try it on another host?

[stebo730]

Unfortunately no, well not quickly and am loathed to spend much time on it. Our existing site, which is very basic runs on the same IIS server and is fine.

[LosOjos]

I'd say that if you're paying a company to develop a website for you, they should be the ones doing the leg work here; have they given you any advice at all or simply given up?

[stebo730]

They have given some advice - obviously in the earlier stages working with IIS and Windows Server would not be a problem. Cut to reality "we mostly do Linux and Apache installations". Their IIS experience is limited.

[3s-gtech]

Do you need it to be on IIS? If you absolutely require it, it may be best to find another host - if not, will Linux and Apache work for you?

[Jamo]

I would try the same site on another host just to rule out something silly with IIS. Are you hosting all the servers (SQL and IIS) on the same box?

[Chris_Cook]

I would agree that the developer should be doing the leg work here, especially if money has been paid. You could maybe try the developer tools in google chrome. The network tab might show which bit is slow. Also you could try mysql workbench, I think that has some monitoring stuff in it. The windows resource monitor on the server may also show up something useful. Do any other sites on this server use mysql or php? How many users are connecting at once?

[crutchfieldj]

Second the above. Right click> Inspect Element in Chrome, click the network tab, reload page. That will show you how long each element of the page takes to load- could be something rogue in there that's slowing it down, like externally-hosted images or third-party plugins.

 

If that doesn't show anything useful up, try it on another host to see if it responds better, just to see if it's the box.

 

This should really be the responsibility of the developer. If they can't fix an issue with their own site...