http://drupal.org/node/251509

Please, help me out, I'm going totally crazy about this!

Thank you very much,

SabbeRubbish

Comments

stevenpatz’s picture

Priority: Critical » Normal
SabbeRubbish’s picture

Priority: Normal » Critical

If you have nothing to add, you obviously have no clue about my issue.
To me it IS critical.

stevenpatz’s picture

Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

That's not what the priority level is for. Also spamming the forums and issue queue with duplicates is frowned upon.

Show us what queries are taking the longest. Then disable the modules ( if possible ) that generate those queries. taht will help narrow it down.

SabbeRubbish’s picture

Thanks for your reply, my queries are not the issue here, as the page loading time is many times greater:
Create content page:

 Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 6820.14 ms.
ms	#	where	query
42.71	0	cache_get	SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:en'
1.92	0	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,3,4,5) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
1.77	0	_nodewords_detect_type_and_ids	SELECT * FROM view_view WHERE url LIKE 'node/add%' AND page = 1
1.23	0	module_list	SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
0.81	0	generate_quickview	SELECT COUNT(nid) AS c FROM comments WHERE status = 1
0.79	0	_node_types_build	SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
...

Watchdog logs;

 Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 6058.16 ms.
ms	#	where	query
178.77	0	cache_get	SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:en'
36.33	0	module_list	SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
28.61	0	_watchdog_get_message_types	SELECT DISTINCT(type) FROM watchdog ORDER BY type
13.51	0	pager_query	SELECT w.wid, w.uid, w.severity, w.type, w.timestamp, w.message, w.link, u.name FROM watchdog w INNER JOIN users u ON w.uid = u.uid ORDER BY w.wid DESC LIMIT 0, 50
5.64	0	pager_query	SELECT COUNT(*) FROM watchdog w INNER JOIN users u ON w.uid = u.uid
1.89	0	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,3,4,5) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
0.89	0	_node_types_build	SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
0.84	0	generate_quickview	SELECT COUNT(nid) AS c FROM comments WHERE status = 1
0.84	0	drupal_lookup_path	SELECT dst FROM url_alias WHERE src = 'admin/logs/pages'
0.8	0	drupal_lookup_path	SELECT dst FROM url_alias WHERE src = 'admin/logs/visitors'
...

My apologies for spamming the forum, but I really want to know what's up with this. And what is the priority used for then?

ainigma32’s picture

@SabbeRubbish: It's been a while... did you ever find out what was causing the site to react that slowly? I just tried clicking through your site a bit and it seems to react just fine now.

- Arie

ainigma32’s picture

Status: Postponed (maintainer needs more info) » Fixed

Looks like SabbeRubbish won't be posting any feedback. Setting this to fixed.

Feel free to reopen if you think that is wrong.

- Arie

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

SabbeRubbish’s picture

Priority: Normal » Minor

´Sorry for late feedback.

Shared hosting was the problem.