[buddypress-trac] [BuddyPress] #1215: Decrease php usage by implementing LIMIT in requests to DB

[buddypress-trac at lists.automattic.com]

#1215: Decrease php usage by implementing LIMIT in requests to DB
-------------------------+--------------------------------------------------
Reporter:  slaFFik       |       Owner:  slaFFik
    Type:  enhancement   |      Status:  new    
Priority:  major         |   Milestone:  1.2    
Keywords:  productivity  |  
-------------------------+--------------------------------------------------
 The main idea is:
 When php makes a request to sort some information (about groups, members,
 blogs) it's reasonable to add sometimes in bp-...-classes.php
 (-templatetags.php and not only there) in:

 {{{
 $wpdb->prepare("SELECT ...");
 }}}

 this:

 {{{
 $wpdb->prepare("Select ... LIMIT 50");
 }}}

 So not all groups, blogs, members will be stored, but 10, 50 or 100. This
 will definitely decrease php usage. And I'm sure, no need to display ALL
 users/groups/blogs in Random mode. 25 will be enough.

-- 
Ticket URL: <http://trac.buddypress.org/ticket/1215>
BuddyPress <http://buddypress.org/>
BuddyPress