Hello, we just finished a new drupal site, forexdistrict.com everything looks and works great.

But the site is very slooooow, its takes a very long time to load. Can someone help us out.

thanks

c

Comments

nevets’s picture

I would start with the firebug extenstion of firefox. For me it showed the page loading in 7.4 seconds with images taking up a good chunk of that time. You could also aggregate and compress CSS files under admin/settings/performance.

There other tool to use is the devel module which ou can configure to show page generation times and times of the sql queries.

Gentoo7’s picture

thank nevets!

i did the aggregate and compress css and it seemed to have helped considerably but the devel report is this:

Executed 65 queries in 150.72 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 877.49 ms.
ms # where query
26.93 1 cache_get SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:en'
24.66 1 pager_query SELECT COUNT(qid) FROM devel_queries
21.95 1 cache_get SELECT data, created, headers, expire FROM cache_views WHERE cid = 'views_tables:en'
18.71 1 drupal_lookup_path SELECT src FROM url_alias WHERE dst = 'front_page'
9.81 1 pager_query SELECT q.qid, q.query, q.function, t.*, COUNT(t.qid) AS count, SUM(t.time) AS total_time, AVG(t.time) AS average, STDDEV(t.time) AS stddev FROM devel_queries q INNER JOIN devel_times t ON q.qid = t.qid GROUP BY t.qid ORDER BY average DESC LIMIT 0, 30
6.99 1 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
5.98 1 module_list SELECT name, filename, throttle, bootstrap FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
3.67 1 db_table_exists SHOW TABLES LIKE 'cache_calendar_ical'
2.62 1 sess_write UPDATE sessions SET uid = 1, cache = 0, hostname = '70.156.131.114', session = 'form|a:6:{s:32:\"45aed2095e84ae051f606c3ba0fac505\";a:2:{s:9:\"timestamp\";i:1185892206;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"5f7c4b484cee37033186df0c54f675f6\";a:2:{s:9:\"timestamp\";i:1185892464;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"dc6e736e979db44e9f651929eb0a9aca\";a:2:{s:9:\"timestamp\";i:1185893544;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"988e16fae6d41c41cdf2140aff8087cb\";a:2:{s:9:\"timestamp\";i:1185900534;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"010fd78cf88c9145d57fbb8bb15fa9ca\";a:2:{s:9:\"timestamp\";i:1185906387;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"29b65fd074af3921fb4b3213dac4a212\";a:2:{s:9:\"timestamp\";i:1185906445;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}}update_total|i:0;', timestamp = 1185906746 WHERE sid = '5c0e874f308e7d69a95fdf8b7054a0ef'
2.25 1 _node_types_build SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
2.19 1 list_themes SELECT * FROM system WHERE type = 'theme'
1.41 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'devel/queries/empty'
1.39 1 _views_load_view SELECT v.* FROM view_view v WHERE v.vid = 1
1.31 1 drupal_lookup_path SELECT src FROM url_alias WHERE dst = 'devel/queries'
1.05 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/11'
0.85 1 locale_supported_languages SELECT locale, name, formula, enabled FROM locales_meta ORDER BY isdefault DESC, enabled DESC, name ASC
0.78 1 _views_load_view SELECT * FROM view_exposed_filter WHERE vid = 1 ORDER BY position ASC
0.77 1 sess_write SELECT sid FROM sessions WHERE sid = '5c0e874f308e7d69a95fdf8b7054a0ef'
0.74 1 block_block SELECT * FROM boxes WHERE bid = 6
0.58 1 _views_load_view SELECT v.* FROM view_view v WHERE v.vid = 10
0.58 1 _views_load_view SELECT v.* FROM view_view v WHERE v.vid = 9
0.54 1 _views_load_view SELECT * FROM view_exposed_filter WHERE vid = 10 ORDER BY position ASC
0.51 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'subscriptions'
0.46 1 sess_write UPDATE users SET access = 1185906746 WHERE uid = 1
0.46 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'glossary'
0.46 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'devel/queries'
0.46 1 _views_load_view SELECT * FROM view_tablefield WHERE vid = 1 ORDER BY position ASC
0.43 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'noticias'
0.43 1 block_list SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
0.41 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'misc/arrow-asc.png'
0.41 1 system_region_list SELECT * FROM system WHERE type = 'theme' AND name = 'garland'
0.41 1 _views_load_view SELECT * FROM view_argument WHERE vid = 1 ORDER BY position ASC
0.4 1 _views_load_view SELECT * FROM view_argument WHERE vid = 9 ORDER BY position ASC
0.39 1 _views_load_view SELECT * FROM view_tablefield WHERE vid = 10 ORDER BY position ASC
0.37 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:0ec08cf24c7445c7b9625296125d5887'
0.36 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:44baf65f63faeef39b69e44f5e4dc8ec'
0.36 1 cache_get SELECT data, created, headers, expire FROM cache_views WHERE cid = 'views_urls'
0.35 1 taxonomy_get_tree SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 2 ORDER BY weight, name
0.35 1 _views_load_view SELECT * FROM view_filter WHERE vid = 9 ORDER BY position ASC
0.35 1 _views_load_view SELECT * FROM view_exposed_filter WHERE vid = 9 ORDER BY position ASC
0.35 1 _views_load_view SELECT * FROM view_tablefield WHERE vid = 9 ORDER BY position ASC
0.34 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '1:98cdf37552921445901758d59a01a21e'
0.34 1 _views_load_view SELECT * FROM view_sort vs WHERE vid = 1 ORDER BY position ASC
0.34 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'forum'
0.34 1 _views_load_view SELECT * FROM view_filter WHERE vid = 1 ORDER BY position ASC
0.33 1 _views_load_view SELECT * FROM view_argument WHERE vid = 10 ORDER BY position ASC
0.33 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'ad_remote/1'
0.33 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'search/node'
0.32 2 calendar_views SELECT vid FROM view_view ORDER BY name
0.32 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'currency'
0.31 1 drupal_lookup_path SELECT COUNT(pid) FROM url_alias
0.31 1 _views_load_view SELECT * FROM view_filter WHERE vid = 10 ORDER BY position ASC
0.3 1 block_block SELECT * FROM boxes WHERE bid = 7
0.3 1 _views_load_view SELECT * FROM view_sort vs WHERE vid = 9 ORDER BY position ASC
0.3 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/62'
0.29 1 _views_load_view SELECT * FROM view_sort vs WHERE vid = 10 ORDER BY position ASC
0.29 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'logout'
0.29 1 block_block SELECT * FROM boxes WHERE bid = 1
0.28 2 calendar_views SELECT vid FROM view_view ORDER BY name
0.28 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'blog/1'
0.27 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'user/1'
0.26 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'calendario'
0.26 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'front_page'
0.26 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'admin'
0.26 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/add'

is this normal?

and i used firebug with the yslow addon too, it says too many http request

C 1. Make fewer HTTP requests

F 2. Use a CDN

F 3. Add an Expires header

A 11. Avoid redirects
A 12. Remove duplicate scripts
A 13. Configure ETags

thanks!

Christefano-oldaccount’s picture

Wim Leers' Improving Drupal's page loading performance article is pretty authoritative on this subject.

kenorb’s picture

You should install APC or XCache library for PHP to make it faster.

If this doesn't help, you may test your website via bench_chart modules (part of http://drupal.org/project/dtools) and will show you which other modules are slowing down (Drupal 6.x).
Also you can try profiling tools like xhprof, xdebug or dbg (integrated with PHPEd IDE).