Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Question Slow load in Kunena 1.6.1

More
13 years 4 months ago #11 by sozzled
No problems. :) I only wish I was able to help you better.

Please Log in or Create an account to join the conversation.

More
13 years 4 months ago #12 by ricslady
Because my site has been so slow just lately, I contacted my web host. This is what I was told. Keep in mind that I'm not a programmer, please. I'm only posting here because I see jos_kunena...

I really need help with this.

Casey: [10:12:21 PM] These queries seem to be the larger portion of cpu usage:
[10:12:23 PM] Sun Dec 12 21:02:18 2010
# Query_time: 3.196955 Lock_time: 0.000438 Rows_sent: 39 Rows_examined: 258141
use simmerss_jml4;
SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments,
l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, c.name AS catname, c.class_sfx
FROM (
SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT null AND f.userid='92') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount,
COUNT(DISTINCT a.id) AS threadattachments COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='92', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='92', m.id, 0)) AS mylastid, MAX(m.time) AS lasttime
FROM jos_kunena_messages AS m LEFT JOIN jos_kunena_favorites AS f ON f.thread = m.thread
LEFT JOIN jos_kunena_attachments AS a ON a.mesid = m.id
WHERE m.hold IN (0) AND m.moved='0' AND m.thread IN (56979,75113,16581,52223,80856,5774,86140,48377,82074,71262,86582,1682,83433,69065,82726,86748,82210,2944,37225,38470)
GROUP BY thread
) AS l
INNER JOIN jos_kunena_messages AS a ON a.thread = l.thread
INNER JOIN jos_kunena_messages_text AS t ON a.id = t.mesid
LEFT JOIN jos_users AS j ON j.id = a.userid
LEFT JOIN jos_kunena_users AS u ON u.userid = j.id
LEFT JOIN jos_kunena_categories AS c ON c.id = a.catid
LEFT JOIN jos_kunena_attachments AS aa ON aa.mesid = a.id
WHERE (a.parent='0' OR a.id=l.lastid )
GROUP BY a.id
ORDER BY lasti DESC

Please Log in or Create an account to join the conversation.

Time to create page: 0.469 seconds