Thousands of User Groups produces very sluggish admin

Need help with the Administration of your Joomla! 2.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
kducey
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 135
Joined: Sat Nov 21, 2009 3:11 pm

Thousands of User Groups produces very sluggish admin

Post by kducey » Tue Feb 21, 2017 7:33 pm

We are using Joomla 2.5 and we have an application where we need to assign unique permissions to our users, and therefore we have created over one thousand user groups. We are adding new users, and need to increase the number of groups even further.

Our site works well with one exception. When changing permissions through the administrator console, it is extremely sluggish, and sometimes will time out. Someone has looked at this issue, and discovered that Joomla will query every group when it loads and saves the user permissions.

We believe we can modify the query, and have it limit the number of groups it will query and write to the DB upon saving.

Is there anyone else who has run into this issue, or someone who has used Joomla with thousands of groups?

Thanks,
Ken

User avatar
dhuelsmann
Joomla! Master
Joomla! Master
Posts: 19658
Joined: Sun Oct 02, 2005 12:50 am
Location: Omaha, NE
Contact:

Re: Thousands of User Groups produces very sluggish admin

Post by dhuelsmann » Tue Feb 21, 2017 7:47 pm

This is not relate to your reported issue. Using 2.5 is very foolish. There are known issues in that series which could allow for compromise of your site. You really need to upgrade to 3.6.5.
Regards, Dave
Past Treasurer Open Source Matters, Inc.
Past Global Moderator
http://www.kiwaniswest.org

kducey
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 135
Joined: Sat Nov 21, 2009 3:11 pm

Re: Thousands of User Groups produces very sluggish admin

Post by kducey » Wed Feb 22, 2017 1:45 pm

Can you please let me know what vulnerabilities you are referring to? It is not possible for us to migrate at this time. Please PM me if you want to speak offline.

User avatar
dhuelsmann
Joomla! Master
Joomla! Master
Posts: 19658
Joined: Sun Oct 02, 2005 12:50 am
Location: Omaha, NE
Contact:

Re: Thousands of User Groups produces very sluggish admin

Post by dhuelsmann » Wed Feb 22, 2017 2:03 pm

Go here https://developer.joomla.org/security-centre.html read pages one through 6 which will take you through the risks you are taking.
Regards, Dave
Past Treasurer Open Source Matters, Inc.
Past Global Moderator
http://www.kiwaniswest.org

itoctopus
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4026
Joined: Mon Nov 25, 2013 4:35 pm
Location: Montreal, Canada
Contact:

Re: Thousands of User Groups produces very sluggish admin

Post by itoctopus » Wed Feb 22, 2017 3:28 pm

Security issues because the use of Joomla 2.5 aside, I suspect you will have the same problem if you move to Joomla 3.6.5. The use of thousands of user groups on a Joomla website is not a recommended practice. User groups are meant to be just a few - if you have a lot, then maybe the technical aspect of why you're doing this needs to be revisited.

When you have many user groups, Joomla will silently load all these user groups on many admin pages (for permission reasons - you can confirm that by viewing the source), which will cause a slowdown on both the server side and the browser side (at one point, your browser will start crashing because of this).
http://www.itoctopus.com - Joomla consulting at its finest
https://twitter.com/itoctopus - Follow us on Twitter


Locked

Return to “Administration Joomla! 2.5”