July 20th, 2005, 17:07
Is there any one here who knows page optimization ???
Please help me to improve Performance
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.
July 21st, 2005, 01:58
I guess the simplest thing for you to do is to use photoshop to optimize all the images.
July 21st, 2005, 05:55
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.
July 21st, 2005, 10:44
stored procedures will not decrease server load, it will do the opposite. Stored procedures mostly increase security.