- Forums
- Support and Presales
- Professional Members Support
- [#7531] List entries showing multiple times after recent update.
[#7531] List entries showing multiple times after recent update.
- jciconsult
- OFFLINE
-
Elite Member
- Posts: 269
- Thanks: 21
- Karma: 10
5 years 2 weeks ago - 5 years 1 week ago #311833
by jciconsult
[#7531] List entries showing multiple times after recent update. was created by jciconsult
We have lists for chapter board members.
Now entries are showing multiple times after updating to the latest cb.
www.cabe.ca/jmv3/index.php/cabe-chapters/cabe-board
Now entries are showing multiple times after updating to the latest cb.
www.cabe.ca/jmv3/index.php/cabe-chapters/cabe-board
Last edit: 5 years 1 week ago by krileon. Reason: Added [#7531] tag to subject
Please Log in to join the conversation.
- jciconsult
- OFFLINE
-
Elite Member
- Posts: 269
- Thanks: 21
- Karma: 10
5 years 2 weeks ago - 5 years 2 weeks ago #311834
by jciconsult
Replied by jciconsult on topic List entries showing multiple times after recent update.
We replaced "libraries/CBLib/CB/Legacy/cbUsersList.php" with the _2.4.1+2019.03.05.13.12.55.d44d7ca43 version and that fixed the issue.
The removal of 'distinct' from the query ~ line 458 probably has something to do with it.
The removal of 'distinct' from the query ~ line 458 probably has something to do with it.
$_CB_database->setQuery( "SELECT COUNT( DISTINCT u.id ) " . $queryFrom );
Last edit: 5 years 2 weeks ago by jciconsult.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68528
- Thanks: 9093
- Karma: 1434
5 years 1 week ago #311855
by krileon
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.
Replied by krileon on topic List entries showing multiple times after recent update.
DISTINCT was removed as it significantly hurt the SQL performance. The duplicates are showing because a user has more than 1 usergroup. Have added a bug ticket to explore other options as adding DISTINCT back isn't an viable option. Sites with 100,000 or more users see 600x performance loss (not an exaggeration; going from 10-20ms to seconds).
forge.joomlapolis.com/issues/7531
Below is a current example if 1 million users.
Current: 0.0311 seconds
GROUP BY: 20.4404 seconds
DISTINCT: 154.7703 seconds
More than likely GROUP BY will be our only solution besides maybe changing to a subquery usage.
forge.joomlapolis.com/issues/7531
Below is a current example if 1 million users.
Current: 0.0311 seconds
GROUP BY: 20.4404 seconds
DISTINCT: 154.7703 seconds
More than likely GROUP BY will be our only solution besides maybe changing to a subquery usage.
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 to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Support and Presales
- Professional Members Support
- [#7531] List entries showing multiple times after recent update.
Time to create page: 0.249 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Professional Members Support
- [#7531] List entries showing multiple times after recent update.