YAFLogo

bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
2011-07-05T16:19:02Z
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

Sponsor
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
2011-07-06T00:13:37Z
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.
UserPostedImage 
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
2011-07-11T15:28:23Z
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
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.0 RC 3
2011-07-11T16:01:50Z
Originally Posted by: bbobb 

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.


UserPostedImage
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
2011-07-11T20:40:13Z
Originally Posted by: tha_watcha 

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.

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
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.0 RC 3
2011-07-13T10:54:25Z
Yes you are right, i must be blind and stupid. Code is updated in Repository
UserPostedImage
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
2011-07-13T12:13:45Z
Originally Posted by: tha_watcha 

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.