Title: Really Slow Admin Last modified: January 26, 2017 --- # Really Slow Admin * Resolved [carlbryanmusic](https://wordpress.org/support/users/carlbryanmusic/) * (@carlbryanmusic) * [9 years, 4 months ago](https://wordpress.org/support/topic/really-slow-admin/) * Cool plugin, really useful! Problem is that it is slowing down the admin area considerably. On every admin page, it’s running 107 queries. A whole bunch of nsau_GetMetaKeys()… etc. * There has got to be a way to reduce this. It’s practically unusable. * —- HOST & SERVER —- PHP Version: 7.0.15 Server Type: Apache/2.4.25 (Unix) OpenSSL/ 1.0.2g MySQL Version: 5.7.17 * —- WORDPRESS —- Version: 4.7.1 Multisite: No Debug Mode: No Plugin Host: Open * —- ACTIVE PLUGINS —- Query Monitor (2.13.2) Gravity Forms (2.1.1) – [http://www.gravityforms.com](http://www.gravityforms.com) WooCommerce Remove Billing Fields for Free Virtual Products (2.0) – [https://gist.github.com/BFTrick/7873168](https://gist.github.com/BFTrick/7873168) Admin Menu Editor Pro (2.4.3) – [http://adminmenueditor.com/](http://adminmenueditor.com/) Advanced Custom Fields PRO (5.5.5) – [https://www.advancedcustomfields.com/](https://www.advancedcustomfields.com/) AffiliateWP – Stripe Payouts (1.0.6) – [http://affiliatewp.com/addons/stripe](http://affiliatewp.com/addons/stripe) AffiliateWP (2.0) – [https://affiliatewp.com](https://affiliatewp.com) AffiliateWP– Affiliate Forms For Gravity Forms (1.0.12) – [https://affiliatewp.com/add-ons/pro/affiliate-forms-for-gravity-forms/](https://affiliatewp.com/add-ons/pro/affiliate-forms-for-gravity-forms/) AffiliateWP – Tiered Rates (1.1) – [http://affiliatewp.com/addons/tiered-affiliate-rates/](http://affiliatewp.com/addons/tiered-affiliate-rates/) Cooked Recipe Plugin (2.3.11) – [http://cooked.boxydemos.com](http://cooked.boxydemos.com) Custom Post Type UI (1.5.1) – [https://github.com/WebDevStudios/custom-post-type-ui/](https://github.com/WebDevStudios/custom-post-type-ui/) Enable Contributor Uploads (1.0) – Essential Grid (2.1.0.1) – [http://www.themepunch.com/essential/](http://www.themepunch.com/essential/) Facebook Comments Plugin (2.3.6) – Google URL Shortener (1.0.0) – Gravity Forms Cookies (1.0.0) – Gravity Forms Logging Add-On (1.1.3) – [http://www.gravityforms.com](http://www.gravityforms.com) Gravity Forms MailChimp Add-On (3.7.3) – [http://www.gravityforms.com](http://www.gravityforms.com) Gravity Forms Survey Add-On (3.1) – [http://www.gravityforms.com](http://www.gravityforms.com) Gravity Forms User Registration Add-On (3.5) – [http://www.gravityforms.com](http://www.gravityforms.com) If Menu (0.6) – [http://wordpress.org/plugins/if-menu/](http://wordpress.org/plugins/if-menu/) PMPro Migrate Fix () – PMPro WooCommerce Fix (1.0.0) – Popup Maker (1.4.21) – [https://wppopupmaker.com/](https://wppopupmaker.com/) Blubrry PowerPress (7.0.3)– [http://create.blubrry.com/resources/powerpress/](http://create.blubrry.com/resources/powerpress/) Q2W3 Fixed Widget (5.0.4) – [http://www.q2w3.ru/q2w3-fixed-widget-wordpress-plugin/](http://www.q2w3.ru/q2w3-fixed-widget-wordpress-plugin/) Recent Posts Widget Extended (0.9.9.6) – [https://www.theme-junkie.com/plugins/recent-posts-widget-extended/](https://www.theme-junkie.com/plugins/recent-posts-widget-extended/) SendGrid (1.10.7) – [http://wordpress.org/plugins/sendgrid-email-delivery-simplified/](http://wordpress.org/plugins/sendgrid-email-delivery-simplified/) User Switching (1.0.9) – [https://johnblackbourn.com/wordpress-plugin-user-switching/](https://johnblackbourn.com/wordpress-plugin-user-switching/) WooCommerce Product Feed (2.0.2) – [https://webappick.com/](https://webappick.com/) Widget Logic (0.57) – [http://wordpress.org/extend/plugins/widget-logic/](http://wordpress.org/extend/plugins/widget-logic/) WooChimp (2.1) – [http://www.rightpress.net/woochimp](http://www.rightpress.net/woochimp) WooCommerce Extended Coupon Features PRO (2.3.7.1) – [http://www.soft79.nl](http://www.soft79.nl) WC Autoship Product Page Options (1.1.0) – [http://wooautoship.com](http://wooautoship.com) WC Autoship Upsell (2.0.0) – [https://wooautoship.com](https://wooautoship.com) WC Autoship (4.1.0) – [http://wooautoship.com](http://wooautoship.com) WooCommerce Bulk Discount (2.4.2) – [http://wordpress.org/plugins/woocommerce-bulk-discount/](http://wordpress.org/plugins/woocommerce-bulk-discount/) WooCommerce Coupon Exclusions (1.1.0) – [http://www.itthinx.com/plugins/woocommerce-coupon-exclusions](http://www.itthinx.com/plugins/woocommerce-coupon-exclusions) WooCommerce Print Invoice & Delivery Note (4.1.5) – [https://github.com/piffpaffpuff/woocommerce-delivery-notes](https://github.com/piffpaffpuff/woocommerce-delivery-notes) WooCommerce Stripe Gateway (3.0.7) – [https://wordpress.org/plugins/woocommerce-gateway-stripe/](https://wordpress.org/plugins/woocommerce-gateway-stripe/) WooCommerce Google Analytics Integration (1.4.0) – [http://wordpress.org/plugins/woocommerce-google-analytics-integration/](http://wordpress.org/plugins/woocommerce-google-analytics-integration/) WooCommerce Shipment Tracking (1.4.4) – [http://www.woothemes.com/products/shipment-tracking/](http://www.woothemes.com/products/shipment-tracking/) WooCommerce Stamps.com API integration (1.2.7) – [http://woothemes.com/products/woocommerce-shipping-stamps/](http://woothemes.com/products/woocommerce-shipping-stamps/) WooCommerce USPS Shipping (4.3.3) – [http://www.woothemes.com/products/usps-shipping-method/](http://www.woothemes.com/products/usps-shipping-method/) WooCommerce (2.6.8) – [https://woocommerce.com/](https://woocommerce.com/) WooSidebars( 1.4.3) – [http://woothemes.com/woosidebars/](http://woothemes.com/woosidebars/) WooCommerce Helper (1.7.2) – [https://woocommerce.com/products/](https://woocommerce.com/products/) Wordfence Security (6.2.10) – [http://www.wordfence.com/](http://www.wordfence.com/) Yoast SEO (4.1) – [https://yoast.com/wordpress/plugins/seo/#utm_source=wpadmin&utm_medium=plugin&utm_campaign=wpseoplugin](https://yoast.com/wordpress/plugins/seo/#utm_source=wpadmin&utm_medium=plugin&utm_campaign=wpseoplugin) WP Facebook Pixel (4.3) – [http://nightshiftapps.com/wp-facebook-pixel/](http://nightshiftapps.com/wp-facebook-pixel/) WP-Piwik (1.0.14) – [http://wordpress.org/extend/plugins/wp-piwik/](http://wordpress.org/extend/plugins/wp-piwik/) WP Support Plus (8.0.1) – [https://wordpress.org/plugins/wp-support-plus-responsive-ticket-system-ticket-system/](https://wordpress.org/plugins/wp-support-plus-responsive-ticket-system-ticket-system/) WP User Avatar (2.0.8) – [http://wordpress.org/plugins/wp-user-avatar/](http://wordpress.org/plugins/wp-user-avatar/) * —- WP FACEBOOK PIXEL —- Version: Entlebucher Mountain Dog (4.3) Settings: Array([ nsa_wpfbp_general_facebook_pixel_id] => 541747676018949 [nsa_wpfbp_general_user_type_tracking] => Array ( [0] => editor [1] => author [2] => contributor [3] => subscriber [ 4] => bbp_keymaster [5] => bbp_spectator [6] => bbp_blocked [7] => bbp_moderator[ 8] => bbp_participant [9] => customer [10] => shop_manager [11] => wp_support_plus_agent[ 12] => wp_support_plus_supervisor ) * [nsa_wpfbp_woocommerce_product_id] => data-product_id [nsa_wpfbp_woocommerce_product_value] => current_price [nsa_wpfbp_woocommerce_product_send_ViewContent] => true [nsa_wpfbp_woocommerce_product_send_AddToCart] => true [nsa_wpfbp_woocommerce_shop_send_AddToCart] => true [nsa_wpfbp_woocommerce_order_recieved_send_purchase] => true ) Viewing 6 replies - 1 through 6 (of 6 total) * [Kokomo](https://wordpress.org/support/users/kokomoweb/) * (@kokomoweb) * [9 years, 2 months ago](https://wordpress.org/support/topic/really-slow-admin/#post-8998658) * Same issue here. Any fixes? * [Kokomo](https://wordpress.org/support/users/kokomoweb/) * (@kokomoweb) * [9 years, 2 months ago](https://wordpress.org/support/topic/really-slow-admin/#post-8998662) * This is the culprit: SELECT DISTINCT(wp_37gfanz9jp_postmeta.meta_key) FROM wp_37gfanz9jp_posts LEFT JOIN wp_37gfanz9jp_postmeta ON wp_37gfanz9jp_posts.ID = wp_37gfanz9jp_postmeta. post_id WHERE wp_37gfanz9jp_posts.post_type = ‘product’ AND wp_37gfanz9jp_postmeta. meta_key != ” AND wp_37gfanz9jp_postmeta.meta_key NOT RegExp ‘(^[_].+$)’ AND wp_37gfanz9jp_postmeta.meta_key NOT RegExp ‘(^[(ksp|nsa)].+$)’ nsau_GetMetaKeys() * in wp-content/plugins/wp-facebook-pixel/inc/NSAUtilities.php:66 * Plugin Author [jacobmhulse](https://wordpress.org/support/users/jacobmhulse/) * (@jacobmhulse) * [9 years, 2 months ago](https://wordpress.org/support/topic/really-slow-admin/#post-8998785) * Hey guys, * Thanks for trying out our plugin! * Short fix, replace this function with the following: * ``` if(!function_exists('nsau_GetMetaKeys')) { function nsau_GetMetaKeys($post_type) { //$cache = get_transient($post_type.'_meta_keys'); //if($cache) return $cache; if(false === ($meta_keys = get_transient($post_type.'_meta_keys'))) { global $wpdb; $query = " SELECT DISTINCT($wpdb->postmeta.meta_key) FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id WHERE $wpdb->posts.post_type = '%s' AND $wpdb->postmeta.meta_key != '' AND $wpdb->postmeta.meta_key NOT RegExp '(^[_].+$)' AND $wpdb->postmeta.meta_key NOT RegExp '(^[(ksp|nsa)].+$)' "; $meta_keys = $wpdb->get_col($wpdb->prepare($query, $post_type)); set_transient($post_type.'_meta_keys', $meta_keys, 60*60*24); //1 day exp } return $meta_keys; } } ``` * We will make sure to optimize this in the future. * Thank you for getting in touch with us and giving us the opportunity to fix the issue! Please let us know if you have any other problems. * [Kokomo](https://wordpress.org/support/users/kokomoweb/) * (@kokomoweb) * [9 years, 2 months ago](https://wordpress.org/support/topic/really-slow-admin/#post-9002227) * It seems to have fixed the issue. Thank-you! * Plugin Author [jacobmhulse](https://wordpress.org/support/users/jacobmhulse/) * (@jacobmhulse) * [9 years, 2 months ago](https://wordpress.org/support/topic/really-slow-admin/#post-9003798) * Glad to hear it Kokomo! * Uploaded version 4.4 which corrects this issue along with a few other minor bugs. * If you feel that our plugin is useful, we ask that you take a moment to give us a 5 star review here: [https://wordpress.org/support/view/plugin-reviews/wp-facebook-pixel#postform](https://wordpress.org/support/view/plugin-reviews/wp-facebook-pixel#postform). If you do not feel we deserve 5 stars yet, please let us know what we can do to earn all 5 stars before submitting a review. * Regards, Jacob * [Kokomo](https://wordpress.org/support/users/kokomoweb/) * (@kokomoweb) * [9 years, 2 months ago](https://wordpress.org/support/topic/really-slow-admin/#post-9004021) * Done! Thanks again. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Really Slow Admin’ is closed to new replies. * ![](https://ps.w.org/wp-facebook-pixel/assets/icon-128x128.png?rev=2142263) * [remarketable](https://wordpress.org/plugins/wp-facebook-pixel/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-facebook-pixel/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-facebook-pixel/) * [Active Topics](https://wordpress.org/support/plugin/wp-facebook-pixel/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-facebook-pixel/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-facebook-pixel/reviews/) * 6 replies * 3 participants * Last reply from: [Kokomo](https://wordpress.org/support/users/kokomoweb/) * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/really-slow-admin/#post-9004021) * Status: resolved