[wp-trac] Re: [WordPress Trac] #5183: General Meta-Data Table

[WordPress Trac]

#5183: General Meta-Data Table
-----------------------------------------+----------------------------------
 Reporter:  filosofo                     |        Owner:  anonymous     
     Type:  enhancement                  |       Status:  reopened      
 Priority:  normal                       |    Milestone:  Future Release
Component:  General                      |      Version:  2.9           
 Severity:  normal                       |   Resolution:                
 Keywords:  needs-patch meta-table meta  |  
-----------------------------------------+----------------------------------

Comment(by Denis-de-Bernardy):

 Replying to [comment:37 mikeschinkel]:
 > Can you actually point to several large WordPress blogs that are
 currently having performance problems explicitly because of existing
 database design?

 Yes. Try blogs that run the various related posts plugins that exist. They
 all have a different approach to fetching related posts. All of these
 approaches are just bad, from a performance standpoint, except the very
 worst of them all (using a MyISAM full text index).

 Then, there are all sorts of horrifying (not to mention paid-for)
 memberships plugins. Most are really using WP Roles (another area where
 much needed change is needed). Each of those that I looked into were
 simply horrifying. Those that don't use WP roles are lacking when it comes
 to transactions/accounting management.

 As you highlight, not many coders understand SQL, and many are prompt to
 treat db tables as huge arrays. For patented examples, try the Vanilla
 forum application. Enable whispers, tags, a plugins that add extra
 filters, and see it bring an NDB cluster to a crawl -- even with a few
 thousand rows.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/5183#comment:38>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software