Skip to:
Content

bbPress.org

Changes between Initial Version and Version 1 of Ticket #2959


Ignore:
Timestamp:
06/06/2016 07:23:05 PM (5 years ago)
Author:
johnjamesjacoby
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #2959 – Description

    initial v1  
    33One problem is favorites & subscriptions are currently stored per-user, serialized in `wp_usermeta`. The reasoning for this originally, was that this meta-data was specific enough to the user that it was okay to keep there.
    44
    5 Another problem is querying for which user IDs are subscribed to which forums or topics requires a specific `FIND_IN_SET` MySQL flag, which ends up transversing those serialized `wp_usermeta` values looking for post IDs. Yuck.
     5Another problem is querying for which user IDs are subscribed to which forums or topics requires a specific `FIND_IN_SET` MySQL flag, which ends up transversing those serialized `wp_usermeta` values looking for post IDs.
     6
     7This logic fails hard with Notifications: when replying to a topic or creating a new topic in a forum, querying for all subscribed users to notify them via email, is a query that does not perform very well when there are millions of rows in `wp_usermeta`.
    68
    79So we have two problems that are very uncharacteristic of bbPress's heritage: performance, simplicity.