[wp-trac] [WordPress Trac] #24044: Add index to wp_options to aid/improve performance

[WordPress Trac]

#24044: Add index to wp_options to aid/improve performance
------------------------------+------------------------------
 Reporter:  DanBUK            |       Owner:
     Type:  enhancement       |      Status:  new
 Priority:  normal            |   Milestone:  Awaiting Review
Component:  Options and Meta  |     Version:  3.6
 Severity:  normal            |  Resolution:
 Keywords:  has-patch         |     Focuses:  performance
------------------------------+------------------------------

Comment (by DanBUK):

 Replying to [comment:31 DanBUK]:
 > (Running on a 2CPU / 2GB KVM Centos 6 VM, gah I just noticed it's only
 MySQL 5.1, will install 5.5 and re-test.)

 I'm getting similar results on 5.5 MyISAM:-


 {{{
 myisam_VARCHAR20_Size_100000_Percent_50 'YES' 0.23201403617859
 myisam_VARCHAR20_INDEXED_Size_100000_Percent_50 'YES' 0.29787020683289
 >> Slower

 myisam_VARCHAR20_Size_100000_Percent_20 'YES' 0.13488883972168
 myisam_VARCHAR20_INDEXED_Size_100000_Percent_20 'YES' 0.12055621147156
 >> Faster

 myisam_VARCHAR20_Size_100000_Percent_5 'YES' 0.086687040328979
 myisam_VARCHAR20_INDEXED_Size_100000_Percent_5 'YES' 0.030073165893555
 >> Faster
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/24044#comment:32>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform