WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #19738, comment 11


Ignore:
Timestamp:
11/23/2014 07:10:48 PM (7 years ago)
Author:
Will Brownsberger
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #19738, comment 11

    initial v1  
    33Seems like WP is optimized for searching for posts using the taxomony framework and then just grabbing meta information about the post as additional data.  A search based on meta information is not a priority for normal blogging and not well supported by WP -- especially a search in which meta information is the only screen in the search so that the database has to plow through a lot of postmeta records.  I am doing a CRM plugin so the number of records being stored as special post-types is much greater than the number of regular posts and the meta searching bogs down.
    44
    5 I was initially trying to write entirerly within WP's data structure, but I concluded that if I was going to be making changes to WP's database to support my plugin, it would do less violence to the framework and involve less risk of conflict simply to add a table to the database with its own well optimized index.  This forced a rewrite of all the data structure of the application, but probably for the better.  It also seems better for performance all round not to clutter the post and postmeta tables with a lot of records that could be effectively partioned in a separate table.
     5I was initially trying to write entirely within WP's data structure, but I concluded that if I was going to be making changes to WP's database to support my plugin, it would do less violence to the framework and involve less risk of conflict simply to add a table to the database with its own well optimized index.  This forced a rewrite of all the data structure of the application, but probably for the better.  It also seems better for performance all round not to clutter the post and postmeta tables with a lot of records that could be effectively partioned in a separate table.
    66
    77/w.