I have 1 admin and 8 each of them moderates 6 forums (in a single group)
173 SQL Queries: 1.379 Seconds (82.72% of Total Page Load Time).

public.yaf_admin_list: 0.094
public.yaf_prov_role_findusersinrole: 0.032
public.yaf_prov_role_findusersinrole: 0.018
public.yaf_prov_role_findusersinrole: 0.009
public.yaf_prov_role_findusersinrole: 0.009
public.yaf_prov_role_findusersinrole: 0.011
public.yaf_prov_role_findusersinrole: 0.005
public.yaf_prov_role_findusersinrole: 0.005
public.yaf_prov_role_findusersinrole: 0.005
public.yaf_prov_role_findusersinrole: 0.032
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.008
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.011
public.yaf_user_get: 0.012
public.yaf_prov_getuser: 0.013
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.025
public.yaf_prov_getuser: 0.015
public.yaf_user_get: 0.008
public.yaf_prov_role_findusersinrole: 0.007
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.011
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.009
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.009
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.007
public.yaf_prov_role_findusersinrole: 0.009
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.008
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.006
public.yaf_prov_role_findusersinrole: 0.007
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.010
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.005
public.yaf_prov_role_findusersinrole: 0.007
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.004
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.010
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.012
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.011
public.yaf_user_get: 0.007
public.yaf_prov_role_findusersinrole: 0.007
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.010
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.004
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.005
public.yaf_prov_role_findusersinrole: 0.008
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.006
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.009
public.yaf_user_get: 0.008
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.004
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.004
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.004
public.yaf_prov_getuser: 0.009
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.006
public.yaf_prov_role_findusersinrole: 0.008
public.yaf_prov_getuser: 0.007
public.yaf_user_get: 0.005
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.009
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.008
public.yaf_user_get: 0.004
public.yaf_prov_getuser: 0.005
public.yaf_user_get: 0.006
public.yaf_prov_getuser: 0.009
public.yaf_user_get: 0.007
public.yaf_prov_getuser: 0.010
public.yaf_user_get: 0.008
public.yaf_prov_role_findusersinrole: 0.007
public.yaf_prov_role_findusersinrole: 0.005
public.yaf_prov_role_findusersinrole: 0.005
public.yaf_prov_role_findusersinrole: 0.009
public.yaf_prov_role_findusersinrole: 0.006
public.yaf_prov_role_findusersinrole: 0.009
public.yaf_forum_listall: 0.019
public.yaf_prov_getuser: 0.006
public.yaf_prov_getuser: 0.010
public.yaf_forum_listall: 0.011
public.yaf_user_list: 0.008
public.yaf_prov_getuser: 0.006
public.yaf_forum_listall: 0.011
public.yaf_user_list: 0.009
public.yaf_prov_getuser: 0.005
public.yaf_forum_listall: 0.010
public.yaf_user_list: 0.006
public.yaf_prov_getuser: 0.009
public.yaf_forum_listall: 0.008
public.yaf_user_list: 0.009
public.yaf_prov_getuser: 0.008
public.yaf_forum_listall: 0.009
public.yaf_user_list: 0.007
public.yaf_prov_getuser: 0.005
public.yaf_forum_listall: 0.008
public.yaf_prov_getuser: 0.008
public.yaf_forum_listall: 0.008
public.yaf_prov_getuser: 0.007

Yuck... most of that must be getting the location information? That's a lot of redundant data... it too bad we can't queue it up or something.

As far as I can see this is simply a bad implementation. Hopefully, the feature developer'll fix it or it can be simply disabled in host settings for forums with several moderators.

As far as I can see this is simply a bad implementation. Hopefully, the feature developer'll fix it or it can be simply disabled in host settings for forums with several moderators.

Currently is dont see a better way parsing all users from a group that have mod. Permissions. Maybe we should add a default moderador role and access mask, that would make things a bit easier.

Yes you are right, i must be blind and stupid. Code is updated in Repository

i must be blind and stupid.

Please, never say so, every programmer or coder is blind and stupid several times per working day day, but if he finds and solves a problem he's clever about the same code corner :-d .

There's a simple criteria: if a query called more then once on a page - there's surely a problem with an optimal code somewhere. More DB calls - more problems and less speed because of data locks.