[buddypress-trac] [BuddyPress Trac] #5950: Editing Pages / Posts in wp-admin creates 50, 000 SQL Queries

buddypress-trac noreply at wordpress.org
Wed Oct 29 05:19:10 UTC 2014


#5950: Editing Pages / Posts in wp-admin creates 50,000 SQL Queries
--------------------------+---------------------
 Reporter:  wcvendors     |       Owner:  djpaul
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  2.2
Component:  Activity      |     Version:  2.1
 Severity:  normal        |  Resolution:  fixed
 Keywords:  has-patch     |
--------------------------+---------------------
Changes (by djpaul):

 * owner:   => djpaul
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"9102"]:
 {{{
 #!CommitTicketReference repository="" revision="9102"
 Mentions: don't prime mention results if the site/user has many
 users/friends.

 Sites with huge amounts of users (and therefore probably many potential
 friendships) can cause the primed result generation to be slow due to
 the number of potential user name lookups/queries made.

 Multisite has a function to help us decide if it’s a large network, but
 it’s not available for regular WordPress, so we also check the logged
 in user’s total friend count. (150 is Dunbar's number.)

 In conjunction with the previous commit, this change should help make
 the pre-cached result generation more performant.

 Fixes #5950. Props imath for original patch.
 }}}

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5950#comment:12>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac


More information about the buddypress-trac mailing list