Skip to:
Content

BuddyPress.org

Opened 14 years ago

Closed 14 years ago

#1215 closed enhancement (fixed)

Decrease php usage by implementing LIMIT in requests to DB

Reported by: slaffik's profile slaFFik Owned by: slaffik's profile slaFFik
Milestone: 1.5 Priority: major
Severity: Version:
Component: Keywords: productivity
Cc: jason_jm

Description

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.

Change History (3)

#1 @jason_jm
14 years ago

  • Cc jason_jm added

#2 @apeatling
14 years ago

There's pretty much always a limit set since there are pagination defaults set.

#3 @apeatling
14 years ago

  • Milestone changed from 1.2 to 1.3
  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.