[buddypress-trac] [BuddyPress Trac] #5572: last_activity migration function is unnecessarily slow

[buddypress-trac]

#5572: last_activity migration function is unnecessarily slow
------------------------------+---------------------------
 Reporter:  boonebgorges      |       Owner:  boonebgorges
     Type:  defect (bug)      |      Status:  closed
 Priority:  normal            |   Milestone:  2.0.1
Component:  Core              |     Version:
 Severity:  normal            |  Resolution:  fixed
 Keywords:  commit has-patch  |
------------------------------+---------------------------
Changes (by boonebgorges):

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


Comment:

 In [changeset:"8333"]:
 {{{
 #!CommitTicketReference repository="" revision="8333"
 When migrating last_activity data, clear all data to avoid duplicates

 Previously, duplicates were avoided with a NOT IN subquery. But this
 caused
 load problems on large installations, where the subquery would return
 many thousands of results.

 Fixes #5572
 }}}

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