[#7531] List entries showing multiple times after recent update.

jciconsult
OFFLINE
Posts: 57
Thanks: 2
Karma: 10

5 years 8 months ago - 5 years 8 months 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

Last edit: 5 years 8 months ago by krileon. Reason: Added [#7531] tag to subject

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

jciconsult
OFFLINE
Posts: 57
Thanks: 2
Karma: 10

5 years 8 months ago - 5 years 8 months 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.

Code:

$_CB_database->setQuery( "SELECT COUNT( DISTINCT u.id ) " . $queryFrom );

Last edit: 5 years 8 months ago by jciconsult.

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

krileon
ONLINE
Posts: 48609
Thanks: 8300
Karma: 1446

5 years 8 months ago #311855 by krileon

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.

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: beat, nant, krileon