Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

User list load very slow

11 years 5 months ago #227528 by deltafidesign
Replied by deltafidesign on topic User list load very slow
I've done a local test.

Completly removed kunena and it's plugin. No way, always load very slow.

Then completly removed GJ, still slow.

Then disabled every non-core plugins, still slow.

Then, started dsinstalling every component, module and plugin, no way still slow. Finally I've removed CBSubs and all plugins and all non-core CB plugins. No way, still slow.

Now I just have J! and CB. With about 25.000 fake users, and different ACL group. All those users have the same usergroups (2 user groups assigned).

Don't really know what else could it be.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48460
  • Thanks: 8280
  • Karma: 1443
11 years 5 months ago #227548 by krileon
Replied by krileon on topic User list load very slow
Enable debug mode then test the userlist and let me know what the query count is on your clean install. If it's a reasonable amount then it's safe to say that's not the issue.


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.

11 years 5 months ago #227558 by deltafidesign
Replied by deltafidesign on topic User list load very slow
Memory usage: 18.03 MB

Queries Database: 85 query

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48460
  • Thanks: 8280
  • Karma: 1443
11 years 5 months ago - 11 years 5 months ago #227562 by krileon
Replied by krileon on topic User list load very slow
Ok, not a memory or query count issue then. My guess is CPU usage. Are you able to monitor local or your hosts CPU usage when trying to view a userlist and see if it spikes really high? Query is likely taking way too long causing CPU usage to skyrocket and slow down. If possible can you upload your cut down testing install to your host in a subdomain or new domain so may debug on it further?


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.
Last edit: 11 years 5 months ago by krileon.

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

11 years 5 months ago #227566 by deltafidesign
Replied by deltafidesign on topic User list load very slow
Sent you a PM.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48460
  • Thanks: 8280
  • Karma: 1443
11 years 5 months ago #227570 by krileon
Replied by krileon on topic User list load very slow
Ok, have discussed with Beat and we'll need to look at this deeper. Please PM phpmyadmin access so we can evaluate the queries. You're likely to need custom indexes for the userlist queries.


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.

Moderators: beatnantkrileon
Powered by Kunena Forum