More than 250 Queries by Recent Topic
- Roland
- OFFLINE
- Posts: 272
- Thanks: 17
- Karma: 11
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 informationhtaccess: 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:
www.simple-quality.de - The Quality-Web-Portal
Please Log in or Create an account to join the conversation.
- krileon
- ONLINE
- Posts: 68609
- Thanks: 9109
- Karma: 1434
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.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in or Create an account to join the conversation.
- Roland
- OFFLINE
- Posts: 272
- Thanks: 17
- Karma: 11
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.
www.simple-quality.de - The Quality-Web-Portal
Please Log in or Create an account to join the conversation.
- krileon
- ONLINE
- Posts: 68609
- Thanks: 9109
- Karma: 1434
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.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in or Create an account to join the conversation.
- Roland
- OFFLINE
- Posts: 272
- Thanks: 17
- Karma: 11
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...
www.simple-quality.de - The Quality-Web-Portal
Please Log in or Create an account to join the conversation.
- krileon
- ONLINE
- Posts: 68609
- Thanks: 9109
- Karma: 1434
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.=> 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...)
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.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...
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in or Create an account to join the conversation.