Is there any one here who knows page optimization ???

[ricky_flare]

Please help me to improve Performance

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.

[overulehost]

I guess the simplest thing for you to do is to use photoshop to optimize all the images.

[ryza]

Well with small databases' the querys should be quick,
it's when u get mass amounts of data that things can get slow, e.g. 600,000 records +

Also having multiple querys on one page can make it slow OR querys INSIDE LOOPS(not good idea).

Also smaller images like overulehost suggested will make the page load faster for people with slow connections.

my suggestion: try to use the least amount of querys as possible*
Heap tables are also fast since it loads straight from memory not harddisk but when server is rebooted data is lost; good for temp data/logging.

[spec]

stored procedures will not decrease server load, it will do the opposite. Stored procedures mostly increase security.