Make WordPress Core

Opened 14 years ago

Closed 13 years ago

Last modified 13 years ago

#12798 closed enhancement (wontfix)

Splitting posts+pages and attachments into separate tables

Reported by: dtorbert's profile dtorbert Owned by: ryan's profile ryan
Milestone: Priority: normal
Severity: normal Version: 2.9.2
Component: Database Keywords: wp_posts attachments partition
Focuses: Cc:


Right now, every post, page, or attachment is stored in the wp_posts table. This means that if you have 10,000 images and 50 posts+pages, every time you go to view a post or a page, it's querying a 10,000-row table instead of a 50-row table.

The table could be split into wp_posts and wp_attachments, then if a query needed to be run that really did require searching both, you would use a view instead.

Written correctly, the schema could be written to allow other kinds of logical partitioning (eg, partitioning post tables by year).

Change History (3)

#1 @jane
14 years ago

  • Milestone changed from 3.0 to Future Release

Taking off 3.0 milestone because we are past feature freeze.

#2 @nacin
13 years ago

  • Milestone Future Release deleted
  • Resolution set to wontfix
  • Status changed from new to closed

No plans to do this.

#3 @Denis-de-Bernardy
13 years ago

And yet, frankly, this'll be so necessary in the long term.

Note: See TracTickets for help on using tickets.