subramanya1 / buddypress-media

Automatically exported from code.google.com/p/buddypress-media
0 stars 0 forks source link

Replace $total_groups = $wpdb... calls with count($paged_skills) to reduce overhead #84

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
[In less than a paragraph, how does the feature work?]

In bp_skills_classes.php there are many $wpdb fetches to get the $paged_skills 
followed by a second $wpdb fetch to get a count of the skills.  Replacing that 
second db fetch with $total_skills = count($paged_skills); would save on 
overhead and halve the number of database fetches

[Why is this feature necessary? What shortcoming does it fix?]
Speeds up buddypress especially for large installations

[Are other social media websites implementing this feature? If so, provide
links to example sites.]

SkillStory.com (but it is a work in progress and has MANY bugs -- but the 
$total_skills works fine)

[Is this feature relevant to many different kinds of websites? Explain
why?]

Relevant to EVERY buddypress site because it will speed all of them up.

[Please attach a sketch / wireframe of the feature to the ticket. (If
applicable)]

Original issue reported on code.google.com by KarenChu...@gmail.com on 10 Aug 2011 at 5:53

GoogleCodeExporter commented 9 years ago
oops, sorry.  This was supposed to go in buddypress

Original comment by KarenChu...@gmail.com on 10 Aug 2011 at 5:57

GoogleCodeExporter commented 9 years ago

Original comment by fanquake on 28 Aug 2011 at 4:00