[wp-trac] [WordPress Trac] #11423: user_nicename should get memcached

[WordPress Trac]

#11423: user_nicename should get memcached
-------------------------------+--------------------------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:     
     Type:  enhancement        |      Status:  new
 Priority:  normal             |   Milestone:  3.0
Component:  Optimization       |     Version:  2.9
 Severity:  normal             |    Keywords:     
-------------------------------+--------------------------------------------
 When displaying an author's page, there are queries:

 {{{
 SELECT ID FROM users WHERE user_nicename='whoever'

 SELECT display_name FROM users WHERE user_nicename = 'whoever'
 }}}

 the second one could be avoided with a non-persistent cache bucket indexed
 on user_nicename. we could store the user_id, for instance.

 both of them could be avoided with the same bucket if the latter is made
 persistent.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/11423>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software