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.
If I set in Kunena configuration Avatare and Profil to kunena everything looks fine (32 MB and 160 Queries instead of 270). If I use CB i have the huge amount. According to Mathias from Kunena CB or CB Subs could make these queries (seeh here: www.kunena.org/forum/168-k-16-support/97759-more-than-250-queries-by-recent-topic ).

I also tried standart and beginner mode in CB Plugin...

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:

Please try disabling the Forum integration and using incubator project CB Forums to see if your queries have been reduced or increased at all. Please ensure your comparing against the plugin enabled and the plugin disabled.

I'd be glad to perform these tests for you with backend login credentials provided via PM.

Please also confirm if you're using GJ or not. I was able to confirm an increase of only 30 queries while using the Forum integration during all my tests, which seams acceptable to perform all the necessary checks.

I observed an increase of only 3 queries while using CB Forums incubator project.

Hello,

with Incubator plugin I have over 300 queries and also 68 MB Memory usage...

I don't use groupjive (at the moment Supergroups) but I plan to switch to groupjive...

I send you login-date per Private Message.

Thanks for help.

Please repair your Joomla install or template as directly to the left of "Queries logged" on frontend should display the count. Without this I can not accurately and quickly determine count differences (sorry I do not have the time to keep scrolling to page and counting each occurrence of 00).

From what I can see reviewing the query log 90% of your queries contain "as ku", none of CBs queries whether forum integration or CB Forums usages such a definition; these are coming from something else.

krileon wrote: Please repair your Joomla install or template as directly to the left of "Queries logged" on frontend should display the count. Without this I can not accurately and quickly determine count differences (sorry I do not have the time to keep scrolling to page and counting each occurrence of 00).

=> Thanks for the info but I think these is not the main problem... I need 4 sec. to see if it's 100 or 200 but I believe that is to much (and these is also not included in my Professional membership...)

krileon wrote: From what I can see reviewing the query log 90% of your queries contain "as ku", none of CBs queries whether forum integration or CB Forums usages such a definition; these are coming from something else.

If I switch in Kunena configuration from CB to Kunena it reduce the ammount from 68 to 32 MB (so I and Mathias from Kunena) think that CB can have something to do with that... These Querie is from a Kunena date but it could be called from the CB sidebar in Kunena... One reason more to plan the future with some other Community-solutions...

=> Thanks for the info but I think these is not the main problem... I need 4 sec. to see if it's 100 or 200 but I believe that is to much (and these is also not included in my Professional membership...)

The issue is your site is not displaying the query count in the debug content. It's simply saying "Queries logged" instead of "xxx queries logged". I don't know the cause, but without this fixed I can't properly test your system to see what is causing the drastic query counts.

If I switch in Kunena configuration from CB to Kunena it reduce the ammount from 68 to 32 MB (so I and Mathias from Kunena) think that CB can have something to do with that... These Querie is from a Kunena date but it could be called from the CB sidebar in Kunena... One reason more to plan the future with some other Community-solutions...

Of course enabling CB will cause your forums to be heavy. On top of loading Kunena API you're loading all of CBs API, that's required as CB needs its API to function. As for the query count I can't suggest the cause due to the above quote.