Title: Not loading table optimization options
Last modified: October 31, 2022

---

# Not loading table optimization options

 *  Resolved [Masud Rana](https://wordpress.org/support/users/yeelloo/)
 * (@yeelloo)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/not-loading-table-to-optimize/)
 * Hi There,
 * We have a relatively large database (45gb).
    Wanted to optimize our tables monthly
   but I see optimizations option are not loading at all ! Probably the size has
   to do something with it ! Is WP Optimize able to handle such data volume ?
 * [https://prnt.sc/abaMJgDxNhcN](https://prnt.sc/abaMJgDxNhcN)
 * Regards
    Masud Rana
    -  This topic was modified 3 years, 7 months ago by [Masud Rana](https://wordpress.org/support/users/yeelloo/).

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [Venkat Raj](https://wordpress.org/support/users/webulous/)
 * (@webulous)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/not-loading-table-to-optimize/#post-16152257)
 * [@yeelloo](https://wordpress.org/support/users/yeelloo/) I’m not sure about the
   issue. Do you see any errors in browser console?
    Or timeout error in the php
   error log file?
 *  Thread Starter [Masud Rana](https://wordpress.org/support/users/yeelloo/)
 * (@yeelloo)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/not-loading-table-to-optimize/#post-16167031)
 * [@webulous](https://wordpress.org/support/users/webulous/) Yes, The request keeps
   hanging for 1.5 mins then
    POST /admin-ajax.php?_fs_blog_admin=true 502 Note:
   I do get tables tab with table information after clicking Refresh data action:
   wp_optimize_ajax subaction: get_table_list
 *  Plugin Contributor [Venkat Raj](https://wordpress.org/support/users/webulous/)
 * (@webulous)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/not-loading-table-to-optimize/#post-16171362)
 * [@yeelloo](https://wordpress.org/support/users/yeelloo/) `502` is a bad gateway
   error
 * According to MDN…
 * > Note: A Gateway might refer to different things in networking and a 502 error
   is usually not something you can fix, but requires a fix by the web server or
   the proxies you are trying to get access through.
 * [https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/502](https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/502)
 * That said, could you please try our CLI commands and see if that works?
 * To list all optimizations
    `wp optimize optimizations`
 * To do optimization
    `wp optimize do-optimization --optimization-id=<optimization_name
   >` eg. `postmeta`

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Not loading table optimization options’ is closed to new replies.

 * ![](https://ps.w.org/wp-optimize/assets/icon-256x256.png?rev=1552899)
 * [WP-Optimize – Cache, Compress images, Minify & Clean database to boost page speed & performance](https://wordpress.org/plugins/wp-optimize/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-optimize/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-optimize/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-optimize/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-optimize/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-optimize/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Venkat Raj](https://wordpress.org/support/users/webulous/)
 * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/not-loading-table-to-optimize/#post-16171362)
 * Status: resolved