[geeklog-devel] performance user groups / roles

[Tom]

I don't have experience with that many groups but I don't think the hit
would be that bad, among other things when checking if the user has
permission Geeklog throws all the groups the user belongs to and puts it in
comma separated list that MySQL uses the IN clause on.

Other things affecting speed (as of Geeklog 2.0.0) are complex topic tree's
and stories and blocks that belong to multiple topics. If your site is
multi-language this will also affect the speed slightly. The number of
visitors on your site at any one time will also affect things.

Geeklog 2.1.0 (currently in development) introduces caching which helps
reduce the processing required in a number of areas. One of the big areas
where time is reduced is the topic tree structure. It is now cached along
with a number of blocks and staticpages.

Tom

-----Original Message-----
From: geeklog-devel-bounces at lists.geeklog.net
[mailto:geeklog-devel-bounces at lists.geeklog.net] On Behalf Of Niemans
Sent: August-22-13 5:45 PM
To: Geeklog Development
Subject: [geeklog-devel] performance user groups / roles


I am wondering if somebody has knowledge / experience / stats on the
performance of GeekLog when:

--- there are many, many groups (>> 200)
--- groups will have a hierarchy (several groups are a member of one or more
other groups)
--- the average user is member of average 6 groups, with minimum 4 and
maximum 12

For Instance:
-- the site will contain all kinds of content and any item "belongs" to a
specific group
-- GeekLog will display all content accessible by the user in his 4 or 6 or
12 groups at a time
Example:
-: groups are country (NL, DE) and city (Rotterdam, Amsterdam, Berlin,
Hamburg); other groups are market (Electronics, Software) and company
(Philips, IBM, Google, NSA); 
-: the Rotterdam group is member of NL; the Philips group is member of
Electronics
case: a user belongs to NL, Rotterdam, Electronics and Philips; all content
is restricted to a specific group
requirement: topics (stories) or downloads display for this user ALL content
available for NL, for Rotterdam, for Electronics, and for Philips. 
 
I need some hints on the performance to avoid falling in death row when the
groups start to accumulate.

Please help.

Wim

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://eight.pairlist.net/mailman/listinfo/geeklog-devel