[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 pento):

 With attachment:dan_test.php, I still had the same result of MyISAM
 getting really slow for large tables:

 {{{
 myisam_VARCHAR20_Size_100000_Percent_50 'YES' 0.97143130302429
 myisam_VARCHAR20_INDEXED_Size_100000_Percent_50 'YES' 11.403997087479
 >> Slower

 myisam_VARCHAR20_Size_100000_Percent_20 'YES' 0.96122975349426
 myisam_VARCHAR20_INDEXED_Size_100000_Percent_20 'YES' 5.91277384758
 >> Slower

 myisam_VARCHAR20_Size_100000_Percent_5 'YES' 0.94139242172241
 myisam_VARCHAR20_INDEXED_Size_100000_Percent_5 'YES' 1.2993580341339
 >> Slower
 }}}

 As much as I'd love to ignore MyISAM, the vast majority of WordPress sites
 use it, including WordPress.com. While we're clearly getting different
 results here, we can't take the risk that other sites will suffer the same
 slowness I'm seeing.

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