Hi,

I have installed Joomla 1.12 with the newest community builder profile. However, its working very very slow. When I have ten users online it hardly loads. I have a dedicated server that only runs joomla so that should not be a problem.

I did a debugging when I clicked a link:

Here is the copy of what the Joomla debugger spit out for me. I’m guessing our slowness comes down to this.

I refreshed the main page and it ran this:



52 queries executed
1
SET sql_mode = 'MYSQL40'

---

2
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering

---

3
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 1

---

4
DELETE FROM jos_session
WHERE (
( time < '1173814569' )
AND guest = 0
AND gid > 0
) OR (
( time < '1173814569' )
AND guest = 1
AND userid = 0
)

---

5
SELECT *
FROM jos_session
WHERE session_id = '9528abebaaf96f6291332e6e9bfe1ff3'

---

6
UPDATE jos_session SET `time`='1173815469',`userid`='65',`usertype`='Super Administrator',`username`='ero',`gid`='2',`guest`='0' WHERE session_id='9528abebaaf96f6291332e6e9bfe1ff3'

---

7
SELECT id, name, email, block, sendEmail, registerDate, lastvisitDate, activation, params
FROM jos_users
WHERE id = 65

---

8
SELECT *
FROM jos_menu
WHERE id = 1

---

9
SELECT COUNT(a.id)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-03-13 12:51' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-03-13 12:51' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 2
AND s.access <= 2
AND cc.access <= 2

---

10
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-03-13 12:51' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-03-13 12:51' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 2
AND s.access <= 2
AND cc.access <= 2
ORDER BY f.ordering
LIMIT 4

---

11
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 2
AND folder = 'content'
ORDER BY ordering

---

12
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'

---

13
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 1 )
ORDER BY ordering

---

14
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '2'
GROUP BY m.id ORDER BY m.parent, m.ordering

---

15
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'

---

16
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1

---

17
SELECT avatar, avatarapproved FROM jos_comprofiler WHERE id = 65

---

18
SELECT count(id) FROM jos_uddeim WHERE toread<1 AND toid=65

---

19
SELECT id FROM jos_menu WHERE published>=0 AND link LIKE '%com_uddeim%'

---

20
SELECT count(*) FROM jos_comprofiler_members WHERE pending=1 AND memberid=65

---

21
SELECT gid FROM jos_users WHERE id = '65'

---

22
SELECT g1.group_id, g1.name
FROM jos_core_acl_aro_groups g1
LEFT JOIN jos_core_acl_aro_groups g2 ON g2.lft <= g1.lft
WHERE g2.group_id =24
ORDER BY g1.name

---

23
SELECT count(*) FROM jos_comprofiler WHERE avatarapproved=0 AND approved=1 AND confirmed=1 AND banned=0

---

24
SELECT count(*) FROM jos_comprofiler_userreports WHERE reportedstatus=0

---

25
SELECT count(*) FROM jos_comprofiler WHERE banned=2 AND approved=1 AND confirmed=1

---

26
SELECT count(*) FROM jos_comprofiler WHERE approved=0 AND confirmed=1

---

27
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1

---

28
SELECT count(*) FROM jos_comprofiler_members WHERE pending=1 AND memberid=65

---

29
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'usermenu'
AND published = 1
AND access <= 2
ORDER BY parent, ordering

---

30
SELECT DISTINCT a.username, b.gid, a.userid as uid, b.usertype AS type
, c.*
FROM jos_session AS a
LEFT JOIN jos_users AS b ON b.username = a.username
LEFT JOIN jos_comprofiler AS c ON (a.userid = c.user_id)
WHERE a.userid != 0 AND a.guest = 0 AND b.gid <= 25

---

31
SELECT count(id) as registered FROM jos_users WHERE usertype <> 'administrator' AND usertype <> 'superadministrator'

---

32
SELECT count(id) FROM jos_users WHERE to_days(registerDate) = to_days(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'

---

33
SELECT count(id) FROM jos_users WHERE yearweek(registerDate) = yearweek(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'

---

34
SELECT count(id) FROM jos_users WHERE month(registerDate) = month(curdate()) AND year(registerDate) = year(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'

---

35
SELECT username FROM jos_users WHERE block='0' AND usertype <> 'administrator' AND usertype <> 'superadministrator' ORDER BY registerDate DESC LIMIT 1

---

36
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-03-13 12:51' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-03-13 12:51' )
AND a.access <= 2 AND cc.access <= 2 AND s.access <= 2
AND ( a.sectionid=4 )
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 5

---

37
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 655
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

38
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 0

---

39
SELECT id
FROM jos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 0

---

40
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 654
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

41
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 653
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

42
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 652
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

43
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 651
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

44
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-03-13 12:51' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-03-13 12:51' )
AND a.access <= 2 AND cc.access <= 2 AND s.access <= 2
AND ( a.sectionid=1 )
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 5

---

45
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 633
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

46
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 632
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

47
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 631
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

48
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 630
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

49
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 629
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

50
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_search'
AND published = 1

---

51
SELECT id FROM jos_menu WHERE link LIKE '%com_joomlaboard%'

---

52
SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname FROM jos_sb_messages AS a, jos_sb_categories AS c WHERE a.catid = c.id AND c.published = 1 AND a.hold = 0 AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 20

I really need to get the speed fixed. Are there any who wants to do some consultancy work to take care of this? please contact me at zuyzuy@gmail.com

Sincerely,

Baard

Ok : small checklist goes here

• Is your dedicated server a VPS or a real dedicated server? If on a VPS, you could be a victim of too many accounts sharing the same CPU, memory and disk.
• Have you tried ping'ing the server to get an idea of the connection?
• Could there be Apache or MySQL misconfiguration issues? Are you caching your queries to the database? This is a very good way of increasing datebase performance. Read this section of the MySQL manual : dev.mysql.com/doc/refman/5.0/en/query-cache.html
• Have you enabled GZIP page compression : there are pros and cons to this method.
• Consider using an opcode cache or likes (APC, eAccelerator) so that PHP doesn't have to recompile your code each and every time. Reduces CPU load.
• In the shell (if you're using Linux or BSD-based systems), run commands like top or netstat to get an idea of what's hogging up resources.
• Make sure there aren't links / references to missing images in your template or posts. This will slow down your site considerably!!
• It looks like you also have joomlaboard installed. Do you have a lot of modules installed? This can decrease performance.
• TIP : Disable site statistics (see configuration panel in Joomla backend!! You can set up an account with Google Analytics instead : shifts the load from your CPU to Google for free.

See forum.joomla.org under the section "Performance" for more tips.

Ford

Post edited by: ford, at: 2007/04/06 11:12