ACL Performance

willo

Joined: 2006-05-24
Posts: 2
Posted: Wed, 2007-05-02 12:40

Our site is reaching 40 000 users on gallery 2 with useralbum and we're starting to suffer severely due to the ACL Performance problem (AFAICS). We're now seeing it bringing down our database server when someone posts enough images.

The performance tips page mentions

Quote:
Don't use a lot of useralbums. This is a shortcoming of the current permission architecture of G2, it scales very badly with the number of ACL IDs (the more different the permissions for different items/albums are, the more ACL IDs you have). This will be corrected soon.

I also found (http://codex.gallery2.org/Gallery2:ACL_Performance), but this was on the 2nd December 2005.

What's the status on this? Is anyone working on this? Can I start hacking away and submit, maybe looking at integrating phpgacl or ldap? or am I wasting my time? Perhaps I should move back to Gallery 1, or another gallery engine altogether?

Quote:
Gallery version = 2.2.1 core 1.2.0.1
PHP version = 5.1.4 apache2handler
Webserver = Apache/2.0.52 (CentOS)
Database = postgres7 8.1.4 3 8.1.4, lock.system=flock
Toolkits = LinkItemToolkit, Thumbnail, ArchiveUpload, Ffmpeg, ImageMagick, Gd, Exif
Acceleration = full/604800, full/86400
Operating system = Linux srv2.studentvillage.co.za 2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:21:39 CDT 2006 i686
Default theme = village
gettext = disabled
Locale = en_GB
Browser = Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.3) Gecko/20061201 Firefox/2.0.0.3 (Ubuntu-feisty)
Rows in GalleryAccessMap table = 16415
Rows in GalleryAccessSubscriberMap table = 16921
Rows in GalleryUser table = 38570
Rows in GalleryItem table = 16816
Rows in GalleryAlbumItem table = 4705
Rows in GalleryCacheMap table = 76135

Any help/comments would be appreciated,

Willo van der Merwe
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2007-05-02 13:14

> What's the status on this? Is anyone working on this?

There's no improvement for this issue and noone's working on it either.
Not to say that we wouldn't like to see this fixed, but we haven't come to it yet.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
willo

Joined: 2006-05-24
Posts: 2
Posted: Wed, 2007-05-02 13:49

Ok, so how difficult will it be to integrate a 3rd party library like phpgacl? I did a couple of grep's on the code for accessListIds and found only a couple of classes that one will have to touch, but it might be much deeper ingrained.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2007-05-02 14:02

> Ok, so how difficult will it be to integrate a 3rd party library like phpgacl?

not as easy as you might thing because we optimized some queries to include go directly to the ACL tables. the permission system can't be replaced easily since it's not clearly separated. you'd have to change a considerable number of other queries that depend on permissions but are not part of the permission system.

also, i'm not sure if phpgacl is the answer / if phpgacl would actually help solving our problem.
we have some ideas how to solve the problem but we haven't started working on the task yet.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage