[wp-trac] Re: [WordPress Trac] #9642: Database Schema Optimizations

[WordPress Trac]

#9642: Database Schema Optimizations
-------------------------------+--------------------------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:  Denis-de-Bernardy
     Type:  defect (bug)       |      Status:  new              
 Priority:  normal             |   Milestone:  2.8              
Component:  Optimization       |     Version:  2.8              
 Severity:  normal             |    Keywords:  has-patch        
-------------------------------+--------------------------------------------

Comment(by Denis-de-Bernardy):

 *grin*. This is sooo much better:

 {{{
 mysql> explain select www_posts.* FROM www_posts  WHERE 1=1  AND
 www_posts.post_type = 'post' AND (www_posts.post_status = 'publish' OR
 www_posts.post_status = 'private')  ORDER BY www_posts.post_date_gmt DESC
 LIMIT 0, 10 \G
 *************************** 1. row ***************************
            id: 1
   select_type: SIMPLE
         table: www_posts
          type: ref
 possible_keys: type_parent,type_date_gmt,type_modified_gmt
           key: type_date_gmt
       key_len: 62
           ref: const
          rows: 304
         Extra: Using where
 1 row in set (0.01 sec)
 }}}

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