[wp-trac] [WordPress Trac] #36436: wp_options table size - cached RSS feeds

[WordPress Trac]

#36436: wp_options table size  - cached RSS feeds
-------------------------+----------------------
 Reporter:  mklusak      |       Owner:
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:  invalid
 Keywords:               |     Focuses:
-------------------------+----------------------
Changes (by pento):

 * status:  new => closed
 * version:  4.4.2 =>
 * resolution:   => invalid
 * milestone:  Awaiting Review =>


Comment:

 Thanks for the ticket, @mklusak!

 There's no performance concern with having this data in the column - the
 TEXT column is designed to store large blobs of text. It doesn't affect
 the speed of queries, as InnoDB is smart enough to skip over those blobs
 of text when scanning the table.

 It doesn't affect WordPress performance, either - the feed transients are
 not automatically loaded when WordPress loads, so they don't cause
 unnecessary data transfer between WordPress and MySQL.

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