YAFLogo

Posted by: bbobb - Tuesday, 5 July 2011 18:19:02
I have 1 admin and 8 each of them moderates 6 forums (in a single group) [b][size=9][color=red]173[/color][/size][/b] 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

Posted by: Jaben - Wednesday, 6 July 2011 02:13:37
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.

Posted by: bbobb - Monday, 11 July 2011 17:28:23
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.

Posted by: tha_watcha - Monday, 11 July 2011 18:01:50
[quote=bbobb;50654]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. [/quote] 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.

Posted by: bbobb - Monday, 11 July 2011 22:40:13
[quote=tha_watcha;50656][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.[/quote] YAF contains everything you need in the place. Moreover, forum_moderators sp is an almost ready functional template for a new team_list sp.

Posted by: tha_watcha - Wednesday, 13 July 2011 12:54:25
Yes you are right, i must be blind and stupid. Code is updated in Repository

Posted by: bbobb - Wednesday, 13 July 2011 14:13:45
[quote=tha_watcha;50669] i must be blind and stupid.[/quote] 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.