Kunena 7.0.4 Released

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

Before posting new topics in this category K 1.5.x Support: Please read this first.

Question Optimize RSS Feed load time

More
15 years 5 months ago - 15 years 5 months ago #70872 by GHz
Hi,
I'm running Kunena 1.5.12 with Joomla 1.5.21. There are 59249 post and 2342 discussion in the forum.
All works ok exept the load time of Rss Feed. If try to get the rss feed (settings: by post, one week) I neew to wait more than one minute to get the response. Looking at the mysql process, i see that the cause of the long time is the query used to get the data from the database:
Code:
SELECT l.id AS lastpostid, l.time AS lastposttime, l.thread, count( m.id ) AS numberposts, l.subject, l.userid, l.name AS lastpostname, l.catid, l.catname, l.message AS lastpostmessage FROM jos_fb_messages AS m, ( SELECT m.time, m.thread, m.id, m.catid, m.userid, m.name, m.subject, c.name AS catname, t.message AS message FROM jos_fb_messages AS m, jos_fb_categories AS c, jos_fb_messages_text AS t WHERE m.id = t.mesid AND m.catid = c.id AND c.published = '1' AND c.pub_access = '0' AND m.hold = '0' AND m.moved = '0' AND m.time > '1289560025' ) AS l WHERE l.time >= m.time AND l.thread = m.thread AND m.hold = '0' AND m.moved = '0' GROUP BY l.id ORDER BY l.time DESC

This query takes more than a minute to run.
If I set kunena to generate the feed by thread, the feed loads immediatly.
There is a solution for this problem? I don't know if this problem is fixed in Kunena 1.6, but I can't upgrade now to kunena 1.6 due to javascript conflict with my template.

Thanks for all the work to the kunena team :)
Bye,
GHz
Last edit: 15 years 5 months ago by GHz.

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

More
15 years 5 months ago #70881 by xillibit
Hello,

I know that the RSS query in K1.6.x is a bit more optimised, i think it's should possible to put this query into K1.5.x.

I don't provide support by PM, because this can be useful for someone else.

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

More
15 years 5 months ago - 15 years 5 months ago #70889 by GHz
Replied by GHz on topic Re: Optimize RSS Feed load time

xillibit wrote: Hello,

I know that the RSS query in K1.6.x is a bit more optimised, i think it's should possible to put this query into K1.5.x.


Hi xillibit,
if you can give me the code I can do some tests :)
Last edit: 15 years 5 months ago by GHz.

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

More
15 years 5 months ago #70919 by sozzled

GHz wrote: I don't know if this problem is fixed in Kunena 1.6, but I can't upgrade now to kunena 1.6 due to javascript conflict with my template.

There are huge performance improvements in K 1.6 and there will be even bigger performance improvements in K 2.0.

As a matter if interest, how long do you think it will take you to resolve the Javascript conflict?

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

More
15 years 5 months ago - 15 years 5 months ago #70954 by GHz
Replied by GHz on topic Re: Optimize RSS Feed load time

sozzled wrote:

GHz wrote: I don't know if this problem is fixed in Kunena 1.6, but I can't upgrade now to kunena 1.6 due to javascript conflict with my template.

There are huge performance improvements in K 1.6 and there will be even bigger performance improvements in K 2.0.

As a matter if interest, how long do you think it will take you to resolve the Javascript conflict?


Hi sozzled,
I've updated my website (link in signature) one month ago from joomla 1.0 with fireboard (oooold!!!) to joomla 1.5 with kunena 1.5 after many month of works. I've made custom modification to my forum (additional profile fields, additional user info in posts). The upgrade from fireboard was not complicated, but in kunena 1.6 I think that I need some time to report my custom modification. Kunena 1.6 require mootools 1.2 that conflict with my template menù (ja_kyanite_II).
So, I've planned to do the next major update (joomla, kunena, template, other extension) to joomla 1.6 when it will be released and stable.
I know that in kunna 1.6 contains many optimization but I hope to find a solution for this problem because I don't think to update the forum soon.
I'm also searching a solution for this things:
  • Topic subscriptions: users need to enable or disable automatic topic subscription, now it's not possible, only the administrator can enable or disable it for all. I've suggested to introduce this feature in the forum at fireboard time (3 years ago).
  • Latest posts module: I've found a module for kunena 1.5 to show forum latest post but it make a query that take many seconds to execute and slow down the website. I'm looking for an optimized module.

Bye,
GHz
Last edit: 15 years 5 months ago by GHz.

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

More
15 years 5 months ago #70968 by sozzled

GHz wrote: So, I've planned to do the next major update (joomla, kunena, template, other extension) to joomla 1.6 when it will be released and stable.
I know that in kunna 1.6 contains many optimization but I hope to find a solution for this problem because I don't think to update the forum soon.

There will not be any official solution provided by the project team for K 1.5. The official solution as far as this problem is concerned, is K 1.6.

Regarding your other off-topic questions:

(1) I do not understand your users' inability to enable or disable topic subscription. Check your setting Kunena Configuration » Frontend » User Related » Allow Subscriptions = Yes

(2) Read what the moderators of this site had to say in Kunena latest posts .

Good luck in finding the performance improvements that you're hoping for in K 1.5. I believe that it will be quicker for you, and much less costly, if you upgraded to K 1.6.

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

Time to create page: 0.274 seconds