I'm having a few issues with a site that i've built, even on my broadband connection the site seems to load very slowly. Despite the fact that the homepage contains the majority of the images used elsewhere on the site it is almost as if they are not being cached as they load again one by one rather than appearing immediately. The site is fully database driven and pretty much every single page contains at least one call to mysql whether to populate a select menu or to populate the products page.
What is the best way to test what it is that is affecting the speed of the site? My sql queries seem to run fast enough in phpmyadmin, will the speed of the queries be the same in operation of the site itself?
i have a functions page that is included in every page that i use like a template. This is about 12k, there is also a .css that is included but this cache's, am i right in thinking though that php files do not cache as i suppose that the loading of the functions page alongside the call to each new page might be causing the slow down.