Urgent: Site takes higher loading time...

macmillan · (#1 (**permalink**))

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.

Aaton35 · (#2 (**permalink**))

Stored procedures can be a great thing although currently they are not supported in the stable version of MySQL. If your site is slow I would check the file size on images you are using and more importantly how many queries you are using on a page. I noticed your home page is quite long and seems to load a lot of data. If you must use more than 3 or 4 separate sql queries you might want to look into adodb http://adodb.sourceforge.net for php. You can write cached sql queries for data that might not be updated or refreshed on a regular basis.