slow loading php site

pcs802 · 05-20-2004, 08:25 PM

I just switched my site from a static page site to a dynamically driven php site. And it seems to hang on loading pages, even the static ones that are left.
Could someone take a look and browse a few pages and see if you can tell what is haging up?
The png files are all tiny, flash files are small as well, and if you watch your network activity, it's not like it's loading some big file, it just sits and waits for a reply from the server or something.
Address is www.bargainmonkey.com
Thanks very much,
Eric

bMind · 05-20-2004, 10:23 PM

I am using DSL connection and it took less than 5 seconds to load the full page, is that slow?

Do you have thousand of rewrite codes in your .htaccess file?

MKJ · 05-21-2004, 02:59 AM

Hi

Can't say i found it all that slow. One big site you have there. On loading a page though there was this error:

Warning: Supplied argument is not a valid MySQL result resource in /home/bargain/includes/browsecat.php on line 50

Could be you need to check all the pages for errors or broken links. On a site that big i don't envy you

.

MKJ
Sites-4u

pcs802 · 05-21-2004, 04:52 AM

yes it is big, actually over 1 million products, but there are only 6 php pages doing all the work so it's rather easy to edit.
Plus there are about 30 static pages for my software sales.
I will forward the error you got to our programmer.
Sometimes the first page or so loads fine, but if you click arounf the categories and sub categories you will run into the slow load thing like it is hung up.

Ferre · 05-21-2004, 05:07 AM

I would center the google ad. It loaded a little slow for me too, here's a tool to check the upload speed of your pages,

http://www.numion.com/

**fishfreek** · 05-21-2004, 05:21 AM

Whats the hardware specs of the server. A php/mysql driven site will be more intensive with the CPU and memory than a static website. When you click a link the delay in having the pages load is mostly server side as the server builds the html from the php and mysql to send ot the browser.

pcs802 · 05-21-2004, 08:37 AM

Max User: 52.0 % CPU Average User: 5.0 % CPU Current User:
3.0 % CPU
Max Total: 68.0 % CPU Average Total: 8.0 % CPU Current
Total: 3.0 % CPU

PIII/800 Mhz
256 MEG RAM
RAID 5 7200 RPM discs

**fishfreek** · 05-21-2004, 09:09 AM

Pages load faster on pages that have fewer mysql queries? It seemed like that to me.

The 256mb of ram is really low for a server doing php and mysql queries on the fly. Your scripts might be able to be steamlined some so they are doing less queries to the database and possibly cache some of the information so it does not have to be built/queried every time.

You could try optimizing the mysql server and giving it more or less ram for its cache aswell and see how performance goes. If you have the ram double it to 512 and see how things run.

zenner · 05-22-2004, 11:40 AM

Something that might be worth considering/checking is whether you're doing a large number of queries with each page load. If the database isn't indexed properly it will slow mysql. Even one insert/select into/from a large table that needs an index could make a lot of difference.

I only mention this as you say you have recently moved to dynamic pages.

BTW, I'm on an 64k ISDN line (for my sins) and it didn't seem particularly slow here.