Ticket #950 (new enhancement)

Opened 3 months ago

Last modified 2 days ago

Move Roles out of user_meta table

Reported by: mdawaffe Assigned to:
Priority: normal Milestone: 1.0
Component: Administration Version: 1.0-beta (trunk)
Severity: normal Keywords:
Cc:

Description

On very large sites, the usermeta table can only be queried by user_id or user_id, meta_key. Querying by meta_value does not scale.

There are a few places where we query the usermeta table looking for users who are keymasters or moderators. These queries fail to complete on large sites.

Attached implements #WP5540 for bbPress/BackPress.

Attachments

950.bbpress.diff (13.3 kB) - added by mdawaffe on 08/27/08 20:57:29.
950.backpress.diff (4.5 kB) - added by mdawaffe on 08/27/08 20:57:39.

Change History

08/27/08 20:57:29 changed by mdawaffe

  • attachment 950.bbpress.diff added.

08/27/08 20:57:39 changed by mdawaffe

  • attachment 950.backpress.diff added.

09/09/08 09:34:56 changed by sambauers

This doesn't have much traction on the WordPress side of things. I doubt we'll see it anytime soon.

11/21/08 12:19:30 changed by sambauers

Although, we don't have to do it the WordPress way, and this might solve some other problems we are having too. One way forward with the WordPress implementation may be to still store the data the old way as well.