Joomla Extensions Club 20,483 posts

[babylontoys Friend babylontoysJoin date: October 2010Posts: 2Downloads:0Uploads:0 Thanks: 2]

#155333

I’ve been having some serious problems with my site’s high CPU usage (88 queries at the last debug). I’ve been trying to narrow down which components/extension are causing the high loads and have noticed that ja comment makes about 24 queries each time the page loads. From my debug:

25.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
26.
SELECT Version() AS version
27.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
28.
SELECT Version() AS version
29.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=149

GROUP BY c.type
30.
SELECT Version() AS version
31.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
32.
SELECT Version() AS version
33.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
34.
SELECT Version() AS version
35.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=150

GROUP BY c.type
36.
SELECT Version() AS version
37.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
38.
SELECT Version() AS version
39.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
40.
SELECT Version() AS version
41.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=148

GROUP BY c.type

44.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
45.
SELECT Version() AS version
46.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
47.
SELECT Version() AS version
48.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=76

GROUP BY c.type
49.
SELECT Version() AS version
50.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
51.
SELECT Version() AS version
52.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
53.
SELECT Version() AS version
54.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=77

GROUP BY c.type
55.
SELECT Version() AS version
56.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
57.
SELECT Version() AS version
58.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
59.
SELECT Version() AS version
60.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=78

GROUP BY c.type
61.
SELECT Version() AS version
62.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
63.
SELECT Version() AS version
64.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
65.
SELECT Version() AS version
66.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=79

GROUP BY c.type
67.
SELECT Version() AS version
68.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
69.
SELECT Version() AS version
70.
SELECT *
FROM jos_jacomment_configs AS s
WHERE s.
GROUP='layout'
71.
SELECT Version() AS version
72.
SELECT count(*) AS total, type
FROM jos_jacomment_items AS c

WHERE 1=1
AND c.OPTION="com_content"
AND c.contentid=80

GROUP BY c.type

24 queries total. I think this is way too many for a single component. Has anyone else experienced similar performance issues? I really need to get these numbers down. I’m on a VPS with a few other sites. Even with cache enabled, it doesn’t help much when users log in. My url is: reginaspektor.org

Help!
Thanks

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#359171

I’ve certainly not seen any issues where I use this component. I would also say those simple queries would not cause a high load on a CPU. They are very basic in what they do so should have very little effect.

P.S. I do like the music of Regina Spektor. Bought one of the albums a couple of months back.

1 user says Thank You to Phill for this useful post

1. babylontoys

[babylontoys Friend babylontoysJoin date: October 2010Posts: 2Downloads:0Uploads:0 Thanks: 2]

#359174

Hey,
I made a post about this in the joomla forums and someone said that the ja comment queries were too many and “unnecessary”. Obviously you guys would probably know better since you’re the devs. I’m no pro at this but I think the commonsense approach would be to eliminate anything that is generating a large number of queries…in this case, ja comment. The only reason I’ve stuck with the component is because it’s far superior to anything else out there. However, it’s very important to get the cpu issue taken care of. I’ve submitted a ticket and hopefully someone can help (fingers crossed).

It’s a very frustrating problem…:((
On a more positive note, it’s always nice to meet a fellow fan – yay!!

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#359177

A quick test would be to disable the component for a short while and see if that reduces the cpu load.

[Author]

Posts