Urgent: Site takes higher loading time...

[kkeithcool]

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.

[Whiteknight]

Well, since i can't see any of the php code, and you havent posted any of it, i will have to take a few stabs in the dark and see if i hit anything.

First off, that site is very large. it also has many many little pictures and images that need to be rendered. to this end, you can expect the site to take a certain amount of time to load.

Next, i need to ask where all those advertisements are coming from? are those ads stored in your database, or are you updating them from an external server? making connections with an external server will cost you time. Also, if you are using a database, is the database on your webserver machine, or is it farmed out to a separate server?

I would need to know a little bit about your architecture too, such as your procedures for accessing the database (they may be slow), and the php scripts used to generate the page (they may be very long, or of an old, slow version of php). There are a number of things that could cause a slow page load.