Question More than 250 Queries by Recent Topic

Hello,

I have a very huge memory usage (68 MB) instead of others sites of my Homepage (30 MB).

Also the recent topic page has got completly 276 queries (and most one from Kunena).

Is that normal? My site: www.simple-quality.de

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 60 seconds | Max execution memory: 72M | Max file upload: 24M

Joomla default template details : rt_syndicate_j15 | author: RocketTheme, LLC | version: 1.5.0 | creationdate: October 3, 2010

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.6.4 | creationdate: 2011-05-07

Kunena version detailled: Installed version: 1.6.4 | Build: 4832 | Version name: Kerkrade | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Simple-Quality-Forum
board_offline	0
board_ofset	0.00
offline_message	<h2>The Forum is currently offline for maintenance.</h2> Check back soon!
enablerss	1
enablepdf	1
threads_per_page	25
messages_per_page	8
messages_per_page_search	15
showhistory	1
historylimit	10
shownew	1
jmambot	1
disemoticons	0
template	default
showannouncement	0
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	350
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	1
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	5
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	2000
imagewidth	2000
imagesize	3500
allowfileupload	0
allowfileregupload	1
filetypes	zip,pdf,txt,doc,gz,tgz,xls,vsd,ppt,mdb,pps
filesize	32000
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	1
userlist_online	0
userlist_avatar	0
userlist_name	0
userlist_username	0
userlist_posts	0
userlist_karma	0
userlist_email	0
userlist_usertype	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	15
showpopsubjectstats	1
popsubjectcount	15
usernamechange	0
rules_infb	1
rules_cid	185
help_infb	0
help_cid	1
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	de-de
fbsessiontimeout	1800
highlightcode	1
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	1
sef	1
sefcats	1
sefutf8	0
showimgforguest	1
showfileforguest	0
pollnboptions	6
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	datetime_today
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	communitybuilder
integration_login	none
integration_avatar	communitybuilder
integration_profile	communitybuilder
integration_private	uddeim
integration_activity	alphauserpoints
boxghostmessage	0
userdeletetmessage	1
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
activity_limit	0
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	1
category_subscriptions	post
topic_subscriptions	every
pubprofile	1

Third-party components: CommunityBuilder 1.4 | UddeIm 2.3

Third-party SEF components: None

Plugins: System - Mootools Upgrade: Enabled | System - Mootools12: Disabled | Kunena Search 1.6.4

Modules: Kunena Latest 1.6.0-RC2 | Kunena Search 1.6.4

And here the queries:

It looks like those queries come from CB or CBSubs integration. I contacted CB team to find out what's causing the queries to be run.

Thanks for help. I tried a view thinks and it looks you are right...

If I set in Kunena configuration Avatare and Profil to kunena everything looks fine (32 MB and 160 Queries instead of 270).

But if one of that with Community Builder than I have 68 MB and 270 queries.

Hope CB-Team can help...

I've not yet got reply -- they seem to be busy.

I posted now in CB-Forum and Krileon will have a look in the backend.

Thanks Mathias for your help...

roland76 wrote: Thanks for help. I tried a view thinks and it looks you are right...

If I set in Kunena configuration Avatare and Profil to kunena everything looks fine (32 MB and 160 Queries instead of 270).

But if one of that with Community Builder than I have 68 MB and 270 queries.

Hope CB-Team can help...

Even 160 is way too high. We run some 30 queries for Kunena itself with the built in caching and scaling. There might be another plugin or component involved in addition to CB.

Thanks for that...

CB (Kylie) says that these queries don't come from CB...

www.joomlapolis.com/forum/153-profession...-recent-topic#166502

Most of the queries are the following one:

These querie comes from

administrator\components\com_kunena\libraries\integration\joomla15\access.php

Actually they come from the integration, because of they do not exist if you disable CB support.

I know where that query comes from and the function is internal function inside KunenaAccess class, which is cached in higher level. So something inside CB integration is calling wrong function (can also be in Kunena itself).

One more strange issue:

My Startsite with latest post module from kunena (WITH CB Integration):

Application afterLoad: 0.001 seconds, 1.00 MB
Application afterInitialise: 0.076 seconds, 8.84 MB
Application afterRoute: 0.085 seconds, 10.07 MB
Application afterDispatch: 0.336 seconds, 21.41 MB
Application afterRender: 1.205 seconds, 68.56 MB
Speichernutzung
71936584
94 Abfragen protokolliert


My Startsite with latest post module from kunena (NONE CB Integration):

Profil zum Laufzeitverhalten
Application afterLoad: 0.001 seconds, 1.00 MB
Application afterInitialise: 0.073 seconds, 8.84 MB
Application afterRoute: 0.082 seconds, 10.08 MB
Application afterDispatch: 0.333 seconds, 21.42 MB
Application afterRender: 0.961 seconds, 41.99 MB
Speichernutzung
44081496
67 Abfragen protokolliert


And without latest post module:

Profil zum Laufzeitverhalten
Application afterLoad: 0.001 seconds, 1.00 MB
Application afterInitialise: 0.075 seconds, 8.84 MB
Application afterRoute: 0.084 seconds, 10.07 MB
Application afterDispatch: 0.335 seconds, 21.39 MB
Application afterRender: 0.842 seconds, 36.59 MB
Speichernutzung
38418536
44 Abfragen protokolliert

roland76 wrote: Thanks for that...

CB (Kylie) says that these queries don't come from CB...

www.joomlapolis.com/forum/153-profession...-recent-topic#166502

Most of the queries are the following one:

Code:

SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1')

These querie comes from

administrator\components\com_kunena\libraries\integration\joomla15\access.php

Hello roland76,

did you find a solution for this issue ?