[wp-trac] [WordPress Trac] #36440: get_results break in wp-admin/options.php if thetable is huge

[WordPress Trac]

#36440: get_results break in wp-admin/options.php if thetable is huge
--------------------------------+-----------------------------
 Reporter:  aoculi              |      Owner:
     Type:  defect (bug)        |     Status:  new
 Priority:  normal              |  Milestone:  Awaiting Review
Component:  Options, Meta APIs  |    Version:  4.4.2
 Severity:  normal              |   Keywords:
  Focuses:  administration      |
--------------------------------+-----------------------------
 If we try to check all values from wp_options table thanks to the admin
 page wp-admin/options.php, the page will be broken if the table is huge
 (on my case more than 100 000 rows).

 A simple pagination feature should fix the issue instead of trying to get
 all results.

 Currently on wp-admin/options.php line 253:
 {{{#!php
 <?php
 $options = $wpdb->get_results( "SELECT * FROM $wpdb->options ORDER BY
 option_name" );
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/36440>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform