YAFLogo

bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
11 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.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
11 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
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
11 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
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
11 years ago
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.
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
11 years ago
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.3
11 years ago
Yes you are right, i must be blind and stupid. Code is updated in Repository
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer Topic Starter
11 years ago
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.
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button