Skip to Content Skip to Menu

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

CB GroupJive 50,000 Groups admin side load error.

  • jminer
  • jminer
  • OFFLINE
  • Posts: 18
  • Thanks: 1
  • Karma: 0
11 years 3 months ago - 11 years 2 months ago #231563 by jminer
Hello,

I am using CB and GroupJive to create a solution. We have to create around 50,000 groups in Group Jive. We are using CSV file to import these group into the DB.

We have imported around 5000 group in GroupJive and they are reflecting perfectly in the frontend, but at the backend when I try to view the groups its takes a lot of time and ultimately a blank page appears.
But when I delete around 2000 groups it populates in the backend as well.

We have a dedicated server -
Intel Xeon E3-1265L 2.5GHz
100 Mbps Uplink
4 GB DDR3 Memory
500 GB RAID-1 Drives
10 TB Bandwidth

PHP setting -
Memory - 2048M
max_execution_time = 3000

We are using CB 1.9 and GroupJive 2.7.0 all latest version.

Whenever we try to view the group from the backend our CPU % utilization of the server show as 96% for this process.

Currently we just have 5000 groups but our target is to have 50,000 groups.

Can anyone suggest how to manage 50,000 groups?

Is there any setting we need to change?



J
Last edit: 11 years 2 months ago by jminer.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48466
  • Thanks: 8280
  • Karma: 1443
11 years 2 months ago #231582 by krileon
Specifically what backend page is it doing this on? Just GJ > Groups? Pagination queries the database for a total number of rows so it can split up properly for pagination. Ensure your pagination is not set to "All" or some crazy high number like 5,000 as you're going to end up forcing it to query and display all 5,000 groups in 1 page.


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.

  • jminer
  • jminer
  • OFFLINE
  • Posts: 18
  • Thanks: 1
  • Karma: 0
11 years 2 months ago #231640 by jminer
Yes its just the GJ > groups page. Pagination is set to show 30 records per page and not any crazy number.

help?

J

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48466
  • Thanks: 8280
  • Karma: 1443
11 years 2 months ago #231650 by krileon
I think it maybe the Parent dropdown, which maybe need to be removed in favor of a text box to filter down the list. Please perform the below edit to disable it and confirm if issue persists.

IN: /components/com_comprofiler/plugin/user/plug_cbgroupjive/admin.cbgroupjive.php
ON: Line 896
FROM:
Code:
$groups = cbgjClass::getGroupOptions();
TO:
Code:
$groups = array();
ON: Line 905
FROM:
Code:
$groups = cbgjClass::getGroupOptions( null, $category );
TO:
Code:
$groups = array();


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.
The following user(s) said Thank You: jminer

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

  • jminer
  • jminer
  • OFFLINE
  • Posts: 18
  • Thanks: 1
  • Karma: 0
11 years 2 months ago #231724 by jminer
Thanks krileon, It works like magic.

J

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

  • jminer
  • jminer
  • OFFLINE
  • Posts: 18
  • Thanks: 1
  • Karma: 0
11 years 2 months ago #231726 by jminer
Shh,

One issue still remains, Once I open groups i.e. GJ -> Groups, the groups load but when i click on the pagination i.e. page 2 or any other page it gives a blank screen again.


J

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

Moderators: beatnantkrileon
Powered by Kunena Forum