wp-admin/options.php page crashes when options or cache data are too large

[dilipbheda]

The wp-admin/options.php page can become unresponsive or crash entirely when the database contains large amounts of options or cached data. This issue is especially noticeable when numerous or bulky _site_transient_ options are present.

Ref: ​https://tinyurl.com/2a9zkfl2, ​https://tinyurl.com/2azkfmwa

Suggested Improvement:
To improve performance and reduce the risk of timeout or memory issues, consider excluding _site_transient_ options from the query that loads options on this page. These are temporary and do not typically need to be managed manually via options.php.

[oglekler]

If you have too many options, you have to do something with it, but most likely not seen thing can only make things worse. So, I think that this need devs feedback to discuss what can an should be done.

And it looks like a different approach that was suggested for the same problem at #25939