Slow Speed with a Delay on Website

slow speed, delayed rendering

[swapshop]

I am having issues with my site and speed.

Created a front landing page that is quick 3-4s to load so this is fine.

Issue is the main classifieds site which is php, html and mysql.

I seem to have a delay only in the /classifieds part of the site. This returns the lastest 10 adverts with features, photos, price etc.

I need some advice on how to fault find this issue.

I downloaded wireshark and all I see is a dealy of 3-5 secs before the page starts to build.

I have started to break down the page from header to body to footer but to be honest I am just guessing at fixing my issue.

Optimized the DB, made all graphics small etc just started with the basics.

Using Firefox with the web dev, Yslow plugins to see if I can locate a area where there is a issue.

Can anyone give me some advice I where I need to start to at least isolate my issue?

Happy to give my URL if needed ...

[jatar_k]

look to the database calls first
we assume that the db is responding adequately, because we can't always do something about that

take a look at the queries, if it is only returning 10 then make sure there is a limit 10 on the query

if you see joins maybe you can reduce displayed data to break the joins or even use multiple queries as they can be faster