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

[macmillan]

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 http://www.direct2deal.com

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.

[spondishy]

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 http://www.direct2deal.com (http://www.direct2deal.com/)

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.

I'll admit, I know little about mySQL, but generally stored procedures run quicker (certainly in Enterprise DB's SQLServer, Orlacle etc) as they are compiled and the server knows the execution path of the server.

This is only one part of the equation. If the queries are running slowly, do you have indexes on the correct columns. Is the data normalised properly?

My guess is the issue still lies with the images on the page. The non-image version runs a lot, lot quicker.

[clasione]

It's running faster than it used to when i first looked at it about a month ago..... Still think you should cut down the size of the index page, but I know your client doesn't want that....

[Enigma121]

The site is "imagetastic!". The most important performance improvement is to colour reduce the images - all of them! We reckon we could reduce image file size to 50% of current values with minimal loss of quality.

Do you really need two navigation bars? Probably not.

You've also used images where they aren't really required. Consider settling for simpler bullet point format, using CSS to apply an appropriate style.

While we are on CSS, remove the bulk of colour attributes from the HTML file and place in an external CSS file, for the reasons why count the number of times on the homepage that you use <td bgcolor="#ffffff". Each could be replaced with a single CSS definition.

Done all that? If you are still struggling (particularly on the database optimisation front), or would like some support to get the image optimisation work done, contact us at sales@enigmaconnections.com

BTW: We would also appreciate some comparison feedback on how long our homepage takes to load (see link below).