[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:
     Type:  defect (bug)      |      Status:  new
 Priority:  normal            |   Milestone:  2.0.1
Component:  Core              |     Version:
 Severity:  normal            |  Resolution:
 Keywords:  commit has-patch  |
------------------------------+--------------------

Comment (by r-a-y):

 > Thanks, r-a-y! But is the DELETE query that slow all by itself?

 It's 65% slower than the stored procedure, but I guess the DELETE query is
 trivial compared to the insertion.

 There's also a bug in the patch.

 In the `DELETE` query, `action = 'last_activity'"` should be `type =
 'last_activity'"`

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