Team page horrors · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

bbobb
100% (Exalted)
YAF Developer Topic Starter

13 years ago

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.011

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.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

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Jaben
100% (Exalted)
YAF Developer

13 years ago

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.

bbobb
100% (Exalted)
YAF Developer Topic Starter

13 years ago

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.

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

13 years ago

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.

Originally Posted by: bbobb

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.

bbobb
100% (Exalted)
YAF Developer Topic Starter

13 years ago

[quote=bbobb;50654]

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.

Originally Posted by: tha_watcha

YAF contains everything you need in the place. Moreover, forum_moderators sp is an almost ready functional template for a new team_list sp.

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2

13 years ago

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

bbobb
100% (Exalted)
YAF Developer Topic Starter

13 years ago

i must be blind and stupid.

Originally Posted by: tha_watcha

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.

Important Information: