Urgent: Site takes higher loading time.....

[kkeith]

Hi........

I am a beginner. I have developed website in Php/MySql. But my home page takes some more time to load in some of the browsers

Check this www direct2deal.com [ Mod Edit: link disabled - paulhiles ]

Can Mysql stored procedures help me? I don't know the concepts of stored procedures. If any buddy in group knows
pl. help me


Its very urgent. Your feedback/suggestions will be highly appreciated.

[speed]

I think you need to take a look at the size of the page before you look to the problems being MySQL related.

The HTML for your home page is a whopping 600K, that's excluding images. I'd expect the HTML portion of a page to be more in the region of 10K.

I'd first break the page into categories e.g. computers, apparel and so on, then once the pages are a more sensible length if performance is still lacking then start optimising MySQL/PHP, at the moment I'd say the transfer time far outweighs the performance of MySQL/PHP

[ADAM Web Design]

speed is absolutely right about the HTML being excessive. But it's not all that hard to fix.

First off, you've got 40 products on that opening page with fairly long descriptions. If you shave that down to 3-5 new products with shorter descriptions, you'll knock off 80-90% of your load time right there.

Note: if you still want to show the deals on other pages, you may want to look into recordset paging. Look up "PHP Recordset Paging" on Google and follow some of the code samples.

Second, get your Javascripts out of your code and put them into separate Javascript files. This will allow a slight speed increase as some browsers cache the Jscripts.