Site is loading very slowly - sometimes 2 minutes for the homepage !

I also run my drupal site on a shared hosting account and the performance is very good. Loading times are very good so i don't think it's a shared hosting problem.

On another website i set up with drupal i had the same problem. Loading times raise to 2 minutes and more. The reason therefore was the audio and playlist module. I disabled those modules and the speed wend up again. Perhaps it's the same problem, try de-activating some modules so you can find out what the problem is.

First, you can run drupal with only the required modules. If the speed is still to slow then it must be something else.

Witch panel do you use for administrating your account? I have cpanel and with cpanel you can see what the serverload is. perhaps you can look for something like that so you can figure out what te load is.
Can you tell us witch server you are? Is there a dedicated mysql server or does apache run on the samen server as mysql?

This link will take you to a speed report which will give you some more info.

http://www.websiteoptimization.com/services/analyze/wso.php?url=http://w...

Regards
gpdinoz
"Everything should be made as simple as possible, but not simpler." - Albert Einstein

2 minutes is pretty ridiculous..cant be anything to do with memory

Do you have any term access or node access modules? Running devel module should tell you exactly how much time each query is taking..so if the page is taking 1 minute..it cant possibly tell you '3 seconds'.

Two things that can help you

a) Is it slow for all 'roles' . If an administrator loads it fast, there is a hint for you
b) firefox has a counter that will tell you how long the page takes to load

http://www.xykonconsulting.com

I had a similar problem on a site with a selfmade module. The problem was in the database: MySQL-tables can have indexes to help the system find information faster. If you google for this you'll find plenty of information, I found this link to get you started: http://http://www.databasejournal.com/features/mysql/article.php/1382791

In the end I had to consider what DB-queries were going on and from there I could track down a column that was not indexed but had a lot of entries and was searched every time. I used phpMyAdmin to make that an indexed column and since then the site was very fast again.

Ok, so I followed the link and got a report on the speed of the site. It said the homepage was 108,941 bytes in size of which 39766 is images. It said this size of page would take 23 seconds to load using a 56k connection - I'm actually using my work computer to access it and I think they have a much faster connection- isdn? . Anyhow, so I removed the images and yes the homepage loaded in about 4 seconds. Aha, I thought it's down to just size. However, I have another test site on the same shared server and tried loading that up. Well, that usually has been taking also a huge amount of time to load- about 2 minutes - and so I expected it to be slow, but actually it too loaded in about 4 seconds ( with similar images !).

So, I've been monitoring how long it takes to load the homepage through today. Over about 10 tries it's taken between 3 and 15 seconds to load, except a short while ago it didn't connect at all and I got a "too many connections" error message. I tried loading the site about two minutes later and it took 29 seconds...but at least it loaded. I would've thought that if the code or database was at fault then there would not be this vast difference in loading times and behaviour. Does this point to a server load sharing problem?

Again, once you've actually got the homepage to come up and you log-in then you can navigate around reasonably quickly. I tried reloading the same page over the space of about 10 minutes. Most times it loaded within a second or so and here's what the developer output showed when a page loaded "fast": (I'm sure experienced developers will know the numebrs at the start of the lines are milli-seconds...just thought I'd say that for newbies like me ) .

******************************************
57.74 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'menu:1:en'
56.19 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=104
49.67 0 user_roles SELECT * FROM role ORDER BY name
43.81 0 tinymce_process_textarea SELECT s.name FROM tinymce_settings s INNER JOIN tinymce_role r ON r.name = s.name WHERE r.rid IN (2,3)
35.64 0 user_load SELECT * FROM users u WHERE uid = 1
28.7 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
28.31 0 pager_query SELECT COUNT(*) FROM node n WHERE n.promote = 1 AND n.status = 1
22.5 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=90
21.35 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=102
19.04 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 90
17.16 0 _privatemsg_get_new_messages SELECT COUNT(*) FROM privatemsg WHERE recipient = '1' AND newmsg = 1 AND recipient_del = 0
15.48 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 104 AND gid=0 AND realm='og_all'
12.61 0 module_list SELECT name, filename, throttle, bootstrap FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
10.55 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 102
9.03 0 node_access_view_all_nodes SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all') OR (gid = 0 AND realm = 'og_public') OR (gid = 0 AND realm = 'og_all') OR (gid = 26 AND realm = 'og_subscriber') OR (gid = 25 AND realm = 'og_subscriber') OR (gid = 37 AND realm = 'og_subscriber') OR (gid = 27 AND realm = 'og_subscriber') OR (gid = 29 AND realm = 'og_subscriber') OR (gid = 28 AND realm = 'og_subscriber') OR (gid = 67 AND realm = 'og_subscriber') OR (gid = 19 AND realm = 'og_subscriber')) AND grant_view >= 1
7.45 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 103
7.06 0 _nodewords_load SELECT * FROM nodewords WHERE type = 'page' AND id = ''
6.42 0 tinymce_profile_load SELECT * FROM tinymce_settings
5.9 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'views_tables:en'
5.59 0 drupal_lookup_path SELECT COUNT(pid) FROM url_alias
5.52 0 tinymce_profile_load SELECT rid FROM tinymce_role WHERE name = 'profile1'
3.98 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 104
3.86 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 90 ORDER BY v.weight, t.weight, t.name
3.82 0 user_block SELECT uid, name FROM users WHERE status != 0 AND access != 0 ORDER BY created DESC LIMIT 0, 5
3.27 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 107
3.04 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 103
3.02 0 views_build_view SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node.nid AS node_nid FROM node node WHERE (node.status = '1') ORDER BY node.created DESC LIMIT 0, 5
3.02 0 devel_node_access_block SELECT na.*, n.title FROM node_access na LEFT JOIN node n ON n.nid = na.nid WHERE na.nid IN (0,90,107,106,104,103,102) ORDER BY na.nid
2.89 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:4e80e3acd95472e60d484901fe2a26c6'
2.68 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = ''
2.66 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 106
2.5 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 90
2.43 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 106
2.39 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 102
2.36 0 forum_load SELECT * FROM forum WHERE vid = 118
2.33 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 90 AND na.realm='og_subscriber' AND na.gid != 0
2.22 0 og_get_subscriptions SELECT n.title, n.type, n.status, ou.* FROM og_uid ou INNER JOIN node n ON ou.nid = n.nid WHERE ou.uid = 1 AND ou.is_active >= 1 ORDER BY n.title
2.18 0 signup_nodeapi SELECT * FROM signup WHERE nid = 90
2.13 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 90 AND gid=0 AND realm='og_all'
2.12 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
2.09 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:002ea44e97ae313bed9deece372833ef'
2.08 0 profile_load_profile SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 1
2.05 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:32debeefda5e74a455957d59b94032b2'
2.05 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 104 AND na.realm='og_subscriber' AND na.gid != 0
2.05 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
2.04 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
2.02 0 lm_paypal_subscribe SELECT * FROM lm_paypal_subscriptions WHERE subid = 1 AND status = 1
1.91 0 gmap_location_user SELECT * FROM location WHERE oid=1 AND type='user'
1.87 0 list_themes SELECT * FROM system WHERE type = 'theme'
1.87 0 user_roles SELECT * FROM role ORDER BY name
1.81 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 104 ORDER BY f.fid DESC
1.78 0 signup_nodeapi SELECT * FROM signup WHERE nid = 102
1.78 0 event_block_upcoming SELECT DISTINCT(n.nid), n.title, n.type, n.status, n.moderate, n.changed, e.event_start FROM node n INNER JOIN event e ON n.nid = e.nid WHERE n.status = 1 AND n.moderate = 0 AND e.event_start >= 1160482959 ORDER BY event_start
1.77 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 103 AND na.realm='og_subscriber' AND na.gid != 0
1.77 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
1.75 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
1.74 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 107 AND na.realm='og_subscriber' AND na.gid != 0
1.69 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
1.67 0 user_load SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
1.6 0 _views_load_view SELECT * FROM view_sort vs WHERE vid = 2 ORDER BY position ASC
1.59 0 aggregator_block SELECT * FROM aggregator_item WHERE fid = 2 ORDER BY timestamp DESC, iid DESC LIMIT 0, 5
1.58 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 116 ORDER BY f.fid DESC
1.53 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 102 ORDER BY v.weight, t.weight, t.name
1.53 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 104
1.52 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 102 AND gid=0 AND realm='og_all'
1.51 0 lm_paypal_subscription SELECT * FROM lm_paypal_subscriptions WHERE subid = 1 AND status = 1
1.49 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 107 AND gid=0 AND realm='og_all'
1.48 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 103 ORDER BY v.weight, t.weight, t.name
1.47 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 107
1.47 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:d7430be0012139d2044c56452a63988d'
1.42 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 104 ORDER BY v.weight, t.weight, t.name
1.4 0 poll_block SELECT MAX(n.created) FROM node n INNER JOIN poll p ON p.nid = n.nid WHERE n.status = 1 AND p.active = 1 AND n.moderate = 0
1.35 0 system_region_list SELECT * FROM system WHERE type = 'theme' AND name = 'bluemarine'
1.35 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 121 ORDER BY f.fid DESC
1.35 0 lm_paypal_user_subscribed SELECT uid, subid, status FROM lm_paypal_subscribers WHERE uid = 1 AND subid = 1
1.34 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 106 AND na.realm='og_subscriber' AND na.gid != 0
1.32 0 signup_nodeapi SELECT * FROM signup WHERE nid = 103
1.32 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
1.3 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=103
1.29 0 signup_nodeapi SELECT * FROM signup WHERE nid = 106
1.28 0 forum_load SELECT * FROM forum WHERE vid = 116
1.27 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 120 ORDER BY f.fid DESC
1.26 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 118 ORDER BY f.fid DESC
1.23 0 _views_load_view SELECT v.* FROM view_view v WHERE v.name = 'latestitems'
1.23 0 signup_nodeapi SELECT * FROM signup WHERE nid = 104
1.22 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=106
1.22 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=107
1.22 0 user_block SELECT uid, name, access FROM users WHERE access >= 1160489859 AND uid != 0 ORDER BY access DESC
1.21 0 _get_profile_client_id SELECT value FROM profile_values WHERE fid = 19 AND uid = 1
1.19 0 pager_query SELECT DISTINCT(n.nid), n.sticky, n.created FROM node n WHERE n.promote = 1 AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 5
1.18 0 statistics_exit INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'node', 'http://www.mbasport.com/', '137.205.177.193', 1, '208f0540e572c6480cfb4b76d0b6bc5b', 2067, 1160490159)
1.17 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 117 ORDER BY f.fid DESC
1.16 0 lm_paypal_subscriptions_block SELECT * FROM lm_paypal_subscriptions WHERE status = 1 AND subid = 1
1.15 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:46f4a983a6f4155a1423e4e07cd56394'
1.13 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
1.13 0 user_block SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1160489859 AND uid = 0
1.13 0 _views_load_view SELECT * FROM view_tablefield WHERE vid = 2 ORDER BY position ASC
1.1 0 statistics_get SELECT totalcount, daycount, timestamp FROM node_counter WHERE nid = 90
1.03 0 taxonomy_get_vocabulary SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 1 ORDER BY v.weight, v.name
1.01 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'views_style_plugins:en'
1 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
0.96 0 signup_nodeapi SELECT * FROM signup WHERE nid = 107
0.96 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 102 AND na.realm='og_subscriber' AND na.gid != 0
0.95 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:6e2e3c49fd2fb5e90d0f09575e0779c5'
0.95 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:8659096663c3fa4e1e4305e75ed95517'
0.93 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 103 AND gid=0 AND realm='og_all'
0.91 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
0.9 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
0.85 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
0.85 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 106 AND gid=0 AND realm='og_all'
0.85 0 block_list SELECT * FROM blocks WHERE theme = 'bluemarine' AND status = 1 ORDER BY region, weight, module
0.84 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 107 ORDER BY v.weight, t.weight, t.name
0.83 0 forum_load SELECT * FROM forum WHERE vid = 117
0.82 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 106 ORDER BY v.weight, t.weight, t.name
0.81 0 _views_load_view SELECT * FROM view_exposed_filter WHERE vid = 2 ORDER BY position ASC
0.78 0 profile_pages_menu SELECT fid,name,title,type from profile_fields
0.78 0 _views_load_view SELECT * FROM view_filter WHERE vid = 2 ORDER BY position ASC
0.77 0 _views_load_view SELECT * FROM view_argument WHERE vid = 2 ORDER BY position ASC
0.74 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'views_with_inline_args:en'
0.74 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
0.73 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
0.72 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
0.68 0 forum_load SELECT * FROM forum WHERE vid = 120
0.61 0 aggregator_block SELECT fid, title, block FROM aggregator_feed WHERE fid = 2
0.58 0 event_get_types SELECT * FROM variable WHERE name like 'event_nodeapi_%'
*****************************************************************

Only once did the page take some substantial time to load , 25 seconds , and here's what developer output showed when it was "slow":

***************************************************************
Executed 125 queries in 24944.32 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 25738.99 ms.ms # where query
4597.96 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 102
4512.7 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 103
3101.53 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 90
2674.69 0 lm_paypal_user_subscribed SELECT uid, subid, status FROM lm_paypal_subscribers WHERE uid = 1 AND subid = 1
2362.94 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 106
770.84 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = ''
744.17 0 forum_load SELECT * FROM forum WHERE vid = 117
652.46 0 _views_load_view SELECT v.* FROM view_view v WHERE v.name = 'latestitems'
629.93 0 forum_load SELECT * FROM forum WHERE vid = 120
569.67 0 user_load SELECT * FROM users u WHERE uid = 1
510.68 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 104
508.19 0 event_block_upcoming SELECT DISTINCT(n.nid), n.title, n.type, n.status, n.moderate, n.changed, e.event_start FROM node n INNER JOIN event e ON n.nid = e.nid WHERE n.status = 1 AND n.moderate = 0 AND e.event_start >= 1160483628 ORDER BY event_start
488.27 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 90
481.68 0 user_block SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1160490529 AND uid = 0
466.78 0 node_load SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 107
395.97 0 forum_load SELECT * FROM forum WHERE vid = 116
348.84 0 user_block SELECT uid, name FROM users WHERE status != 0 AND access != 0 ORDER BY created DESC LIMIT 0, 5
346.36 0 statistics_exit INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'node', 'http://www.mbasport.com/?q=admin/settings/devel', '137.205.177.193', 1, '208f0540e572c6480cfb4b76d0b6bc5b', 25390, 1160490833)
328.52 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 107
243.26 0 user_block SELECT uid, name, access FROM users WHERE access >= 1160490529 AND uid != 0 ORDER BY access DESC
18.56 0 poll_block SELECT MAX(n.created) FROM node n INNER JOIN poll p ON p.nid = n.nid WHERE n.status = 1 AND p.active = 1 AND n.moderate = 0
12.69 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'menu:1:en'
9.63 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'views_tables:en'
7.66 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
4.9 0 signup_nodeapi SELECT * FROM signup WHERE nid = 102
4.39 0 lm_paypal_subscribe SELECT * FROM lm_paypal_subscriptions WHERE subid = 1 AND status = 1
4.13 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 102 ORDER BY v.weight, t.weight, t.name
4.09 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 120 ORDER BY f.fid DESC
3.16 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 106 AND gid=0 AND realm='og_all'
3.06 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=106
2.86 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 106 ORDER BY v.weight, t.weight, t.name
2.51 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 118 ORDER BY f.fid DESC
2.47 0 module_list SELECT name, filename, throttle, bootstrap FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
2.41 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
2.34 0 lm_paypal_subscriptions_block SELECT * FROM lm_paypal_subscriptions WHERE status = 1 AND subid = 1
2.32 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 106 AND na.realm='og_subscriber' AND na.gid != 0
2.26 0 lm_paypal_subscription SELECT * FROM lm_paypal_subscriptions WHERE subid = 1 AND status = 1
2.18 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 102
2.17 0 user_roles SELECT * FROM role ORDER BY name
2.11 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 104 AND na.realm='og_subscriber' AND na.gid != 0
2.06 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 104
2.05 0 _views_load_view SELECT * FROM view_exposed_filter WHERE vid = 2 ORDER BY position ASC
2.02 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=103
1.95 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
1.93 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:46f4a983a6f4155a1423e4e07cd56394'
1.93 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
1.93 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 106
1.92 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 107 AND gid=0 AND realm='og_all'
1.9 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 103 AND na.realm='og_subscriber' AND na.gid != 0
1.89 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 102 AND na.realm='og_subscriber' AND na.gid != 0
1.87 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 116 ORDER BY f.fid DESC
1.87 0 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 103
1.86 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
1.85 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
1.85 0 signup_nodeapi SELECT * FROM signup WHERE nid = 107
1.84 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 103 ORDER BY v.weight, t.weight, t.name
1.81 0 signup_nodeapi SELECT * FROM signup WHERE nid = 106
1.8 0 devel_node_access_block SELECT na.*, n.title FROM node_access na LEFT JOIN node n ON n.nid = na.nid WHERE na.nid IN (0,90,107,106,104,103,102) ORDER BY na.nid
1.8 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
1.79 0 theme_forum_topic_navigation SELECT DISTINCT(n.nid), n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 1 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc
1.78 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 121 ORDER BY f.fid DESC
1.78 0 taxonomy_get_vocabulary SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 1 ORDER BY v.weight, v.name
1.78 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 102 AND gid=0 AND realm='og_all'
1.78 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
1.77 0 tinymce_profile_load SELECT rid FROM tinymce_role WHERE name = 'profile1'
1.77 0 _privatemsg_get_new_messages SELECT COUNT(*) FROM privatemsg WHERE recipient = '1' AND newmsg = 1 AND recipient_del = 0
1.76 0 _get_profile_client_id SELECT value FROM profile_values WHERE fid = 19 AND uid = 1
1.76 0 aggregator_block SELECT * FROM aggregator_item WHERE fid = 2 ORDER BY timestamp DESC, iid DESC LIMIT 0, 5
1.75 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'views_style_plugins:en'
1.74 0 profile_pages_menu SELECT fid,name,title,type from profile_fields
1.71 0 gmap_location_user SELECT * FROM location WHERE oid=1 AND type='user'
1.68 0 views_build_view SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node.nid AS node_nid FROM node node WHERE (node.status = '1') ORDER BY node.created DESC LIMIT 0, 5
1.67 0 _nodewords_load SELECT * FROM nodewords WHERE type = 'page' AND id = ''
1.65 0 node_access_view_all_nodes SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all') OR (gid = 0 AND realm = 'og_public') OR (gid = 0 AND realm = 'og_all') OR (gid = 26 AND realm = 'og_subscriber') OR (gid = 25 AND realm = 'og_subscriber') OR (gid = 37 AND realm = 'og_subscriber') OR (gid = 27 AND realm = 'og_subscriber') OR (gid = 29 AND realm = 'og_subscriber') OR (gid = 28 AND realm = 'og_subscriber') OR (gid = 67 AND realm = 'og_subscriber') OR (gid = 19 AND realm = 'og_subscriber')) AND grant_view >= 1
1.65 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
1.65 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
1.62 0 profile_load_profile SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 1
1.61 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 104 AND gid=0 AND realm='og_all'
1.56 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 2 ORDER BY weight, name
1.54 0 list_themes SELECT * FROM system WHERE type = 'theme'
1.53 0 event_get_types SELECT * FROM variable WHERE name like 'event_nodeapi_%'
1.5 0 signup_nodeapi SELECT * FROM signup WHERE nid = 90
1.49 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 90 ORDER BY v.weight, t.weight, t.name
1.49 0 pager_query SELECT COUNT(*) FROM node n WHERE n.promote = 1 AND n.status = 1
1.48 0 _views_load_view SELECT * FROM view_filter WHERE vid = 2 ORDER BY position ASC
1.47 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:4e80e3acd95472e60d484901fe2a26c6'
1.37 0 og_get_subscriptions SELECT n.title, n.type, n.status, ou.* FROM og_uid ou INNER JOIN node n ON ou.nid = n.nid WHERE ou.uid = 1 AND ou.is_active >= 1 ORDER BY n.title
1.35 0 aggregator_block SELECT fid, title, block FROM aggregator_feed WHERE fid = 2
1.3 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 104 ORDER BY v.weight, t.weight, t.name
1.22 0 _views_load_view SELECT * FROM view_tablefield WHERE vid = 2 ORDER BY position ASC
1.15 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=104
1.12 0 drupal_lookup_path SELECT COUNT(pid) FROM url_alias
1.09 0 signup_nodeapi SELECT * FROM signup WHERE nid = 104
1.04 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 104 ORDER BY f.fid DESC
1.02 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:d7430be0012139d2044c56452a63988d'
1 0 taxonomy_get_term SELECT * FROM term_data WHERE tid = 1
0.98 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=102
0.97 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 103 AND gid=0 AND realm='og_all'
0.9 0 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 117 ORDER BY f.fid DESC
0.88 0 _views_load_view SELECT * FROM view_sort vs WHERE vid = 2 ORDER BY position ASC
0.87 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=107
0.84 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
0.82 0 block_list SELECT * FROM blocks WHERE theme = 'bluemarine' AND status = 1 ORDER BY region, weight, module
0.82 0 signup_nodeapi SELECT * FROM signup WHERE nid = 103
0.8 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:8659096663c3fa4e1e4305e75ed95517'
0.77 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:002ea44e97ae313bed9deece372833ef'
0.77 0 forum_load SELECT * FROM forum WHERE vid = 118
0.74 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:32debeefda5e74a455957d59b94032b2'
0.72 0 user_roles SELECT * FROM role ORDER BY name
0.7 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 107 AND na.realm='og_subscriber' AND na.gid != 0
0.7 0 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 107 ORDER BY v.weight, t.weight, t.name
0.7 0 _views_load_view SELECT * FROM view_argument WHERE vid = 2 ORDER BY position ASC
0.69 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
0.68 0 tinymce_profile_load SELECT * FROM tinymce_settings
0.67 0 og_node_load_public SELECT grant_view FROM node_access WHERE nid = 90 AND gid=0 AND realm='og_all'
0.65 0 taxonomy_get_parents SELECT t.tid, t.* FROM term_data t INNER JOIN term_hierarchy h ON h.parent = t.tid WHERE h.tid = 1 ORDER BY weight, name
0.62 0 gsitemap_nodeapi SELECT priority_override FROM gsitemap WHERE nid=90
0.59 0 tinymce_process_textarea SELECT s.name FROM tinymce_settings s INNER JOIN tinymce_role r ON r.name = s.name WHERE r.rid IN (2,3)
0.57 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'filter:1:6e2e3c49fd2fb5e90d0f09575e0779c5'
0.56 0 og_get_node_groups SELECT na.gid, n.title FROM node_access na INNER JOIN node n ON na.gid = n.nid WHERE na.nid = 90 AND na.realm='og_subscriber' AND na.gid != 0
0.55 0 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'views_with_inline_args:en'
0.53 0 system_region_list SELECT * FROM system WHERE type = 'theme' AND name = 'bluemarine'
0.51 0 pager_query SELECT DISTINCT(n.nid), n.sticky, n.created FROM node n WHERE n.promote = 1 AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 5
0.49 0 user_load SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
0.4 0 statistics_get SELECT totalcount, daycount, timestamp FROM node_counter WHERE nid = 90
*************************************************************************

Are these two differnet results and outputs indicative that the server is just taking more time to get the information from the database ( looking at the lines with "node load" at the start )? I'm still very new to all this so forgive my non-techy view on things. By all means please go to www.mbasport.com and tell me whether it loaded fast or slow.

Thanks for your comments. I had realised that the browser cache would have an effect so I have been clearing it before loading and timing pages. Also, I did try turning off the Google Adsense and Maps....aswell as news aggregator...again no "consistent" difference in performance when these were enabled or not. Any more ideas to try from anybody would be welcome.