Slowness

Sillysoft

Ok question about what could be causing the slowness of php and or mysql. First a explanation:

I currently am creating a web app that is up on my provider. It runs very fast. The server is linux running apache yada yada yada. With a fat pipe yada yada yada.

Now Im trying to host the site locally on my system at home. The webserver is running Windows 2003 (.net Server Enterprise) with IIS 6. It is a p2 400 with 192 megs of ram. The hdd is 10.2 gigs at 5400 rpm. The connection is cable with 256 up and 3 megs down.

I have php 4.3.1 installed and mysql 4.1 installed. All default installations. Now when I access the site on my box static html comes up pretty quickly. Heck even the login and first page go really fast. The first page contains 3 queries to get the count of rows for the 3 things I need to count, then echos out the count.

That runs very fast. But when I go to a page that uses joins even with like 2 records, it takes a long time. Meaning like 4-5 seconds. So can any give me some direction on what could be causing this? Perhaps there is a tool or command I can use to see if mysql is the bottleneck? Or maybe it is just the hardware and or the connection? I read through mysql manual and it can easily take up a lot of memory with queries so I wonder if that is the issue because 2003 server recommends bare bone 400 mhz I believe.

But I wanted to see if there was a way to test if it is hardware or configuration. BTW I need to stick with a Windows OS for business reasons

Thanks
Silly

Sillysoft

I checked the requirements for Windows 2k3 enterprise. Minumum processor speed is 133, they recommend a 733 or higher. Memory minimum is 128, recommended 256 or higher. This is just to run the windows OS.

Im just hoping it is a hardware issue, IMO it is easier to upgrade hardware than it is to tweak the software (If it can be tweaked)

So any input would be appreciated

Thanks
Silly

feldon23

Are you setting this up to teach yourself IIS and Win2k3 Server or are you just trying to get a server up and running?

Sillysoft

Trying to get the server up and running here. Also I notice when doing loops, for instance doing a while statement that loops 100 times, it chugs BIG TIME. Then I put the same script up on my providers server which doesnt have a fast connection but a decent system, it flies.

Thanks
Silly

feldon23

It makes little sense to use IIS/Windows Server 2003 if you are going to be using Apache/PHP/MySQL instead of IIS/ASP/MSSQL.

stolzyboy

are you using php/iis/mysql, cuz that is one of the most unstable combinations possible

Sillysoft

Ok just for the record, I understand Windows and IIS were not meant for open source languages like PHP. But I do not have a choice at this point, it has to be on a Windows OS. I could however use Apache if I bitch enough

Thanks
Silly

stolzyboy

then start bitching.......my .02 cents

Sillysoft

Should I go back to Windows 2000 or stay with .net server (Enterprise) or all MS OS are evil? 🙂

Silly

stolzyboy

i really don't like developing anything php/mysql/apache, but it seems to work fine on my win2k pro install i have heard of people running server having problems, but i don't think you really need the .NET package, bloated to high heaven

BeastRider

Originally posted by Sillysoft
Ok just for the record, I understand Windows and IIS were not meant for open source languages like PHP. But I do not have a choice at this point, it has to be on a Windows OS. I could however use Apache if I bitch enough
Silly

I'm running Sambar Server in place of IIS (www.sambar.com). Easy to set up, works well, and so far php has worked flawlessly with it.