• Resolved negapo

    (@negapo)


    Hi, I’ve been a long-time user of SiteGround and both of your plugins. There is no way you can develop a speed optimization and security plugin and then not optimize the codebase and be this sloppy. I have 118 entries in the “wp_options” table, and 109 have autoload set to yes.

    My guess is that many of them are old entries from past versions of the plugin and are not needed anymore. The majority of the entries may not need autoload. Do you really need to autoload the version, the notification email, a lot of configuration settings, etc.? Isn’t it possible to group many of these entries into one or two JSON fields? Is it too hard to clean up old entries when upgrading versions or on uninstall?

    This is my current list of entries:

    external_updates-siteground-wizard
    sg_security_server_address
    siteground_optimizer_default_autoflush_cache
    siteground_optimizer_default_enable_cache
    siteground_optimizer_image_optimization_completed
    siteground_optimizer_image_optimization_status
    siteground_optimizer_image_optimization_stopped
    siteground_optimizer_supercacher_permissions
    sg_cachepress
    sg_security_current_version
    sg_security_delete_readme
    sg_security_disable_activity_log
    sg_security_disable_feed
    sg_security_disable_file_edit
    sg_security_disable_usernames
    sg_security_disable_xml_rpc
    sg_security_hsts_protection
    sg_security_lock_system_folders
    sg_security_login_attempts
    sg_security_login_type
    sg_security_login_url
    sg_security_notification_emails
    sg_security_sg2fa
    sg_security_total_blocked_logins
    sg_security_total_blocked_visits
    sg_security_unsuccessful_login
    sg_security_update_timestamp
    sg_security_version
    sg_security_weekly_email_timestamp
    sg_security_wp_remove_version
    sg_security_xss_protection
    sgal_adjusted_bounce_rate
    sgal_anonymize_ip
    sgal_cookie_notice_name
    sgal_enqueue_order
    sgal_ga_cookie_expiry_days
    sgal_script_position
    sgal_track_admin
    sgal_tracking_id
    sgo_install_7_4_0
    sgo_install_service
    sgo_install_service_7_3_0
    sgs_install_1_4_4
    siteground_data_consent
    siteground_optimizer_assets_data
    siteground_optimizer_async_javascript_exclude
    siteground_optimizer_autoflush_cache
    siteground_optimizer_blocking_plugins_notice
    siteground_optimizer_cloudflare_auth_key
    siteground_optimizer_cloudflare_email
    siteground_optimizer_cloudflare_optimization
    siteground_optimizer_cloudflare_optimization_status
    siteground_optimizer_cloudflare_zone_id
    siteground_optimizer_combine_css
    siteground_optimizer_combine_css_exclude
    siteground_optimizer_combine_google_fonts
    siteground_optimizer_combine_javascript
    siteground_optimizer_combine_javascript_error
    siteground_optimizer_combine_javascript_exclude
    siteground_optimizer_current_version
    siteground_optimizer_database_optimization
    siteground_optimizer_disable_emojis
    siteground_optimizer_dns_prefetch
    siteground_optimizer_dns_prefetch_urls
    siteground_optimizer_enable_browser_caching
    siteground_optimizer_enable_cache
    siteground_optimizer_enable_gzip_compression
    siteground_optimizer_enable_memcached
    siteground_optimizer_excluded_lazy_load_classes
    siteground_optimizer_excluded_lazy_load_media_types
    siteground_optimizer_excluded_urls
    siteground_optimizer_file_cache_secret
    siteground_optimizer_file_caching
    siteground_optimizer_first_run
    siteground_optimizer_fix_insecure_content
    siteground_optimizer_flush_redux_cache
    siteground_optimizer_fonts_preload_urls
    siteground_optimizer_has_cloudflare
    siteground_optimizer_heartbeat_dashboard_interval
    siteground_optimizer_heartbeat_frontend_interval
    siteground_optimizer_heartbeat_post_interval
    siteground_optimizer_hide_rating
    siteground_optimizer_lazyload_images
    siteground_optimizer_logged_in_cache
    siteground_optimizer_memcache_dropin_crashed
    siteground_optimizer_memcache_notice
    siteground_optimizer_minify_javascript_exclude
    siteground_optimizer_optimize_css
    siteground_optimizer_optimize_html
    siteground_optimizer_optimize_images
    siteground_optimizer_optimize_javascript
    siteground_optimizer_optimize_javascript_async
    siteground_optimizer_optimize_web_fonts
    siteground_optimizer_phpcompat_is_compatible
    siteground_optimizer_phpcompat_progress
    siteground_optimizer_phpcompat_result
    siteground_optimizer_phpcompat_status
    siteground_optimizer_preheat_cache
    siteground_optimizer_preload_combined_css
    siteground_optimizer_purge_rest_cache
    siteground_optimizer_quality_type
    siteground_optimizer_quality_webp
    siteground_optimizer_remove_query_strings
    siteground_optimizer_resize_images
    siteground_optimizer_show_notice
    siteground_optimizer_smart_cache_purge_queue
    siteground_optimizer_ssl_enabled
    siteground_optimizer_total_non_converted_images
    siteground_optimizer_total_unoptimized_images
    siteground_optimizer_update_timestamp
    siteground_optimizer_user_agent_header
    siteground_optimizer_version
    siteground_optimizer_webp_support
    siteground_optimizer_whats_new
    siteground_settings_optimizer
    siteground_settings_security
    siteground_wizard_activation_redirect

    The first 8 do not autoload, everything else autoloads, its very little in terms of size but its just unneeded, does not show consideration to users installations and it’s very easy to fix on your side.

    Could you please point out in the list old unneeded entries and which ones should really autoload? Thanks

Viewing 1 replies (of 1 total)
  • Plugin Support Pavel Dosev

    (@pdosev)

    Hello @negapo,

    We are constantly monitoring and optimizing our plugins. Each entry in your database table serves a specific purpose. All the options the plugin uses are used to store settings related to plugin functionality and user settings, ensuring that all functionalities are working correctly and securing/optimizing the websites.

    Still, from the ones you listed, the sgal_ options are not used by our plugins and are not related to our products. Our plugin uses the sgo_/sgs_install options for updates, but these are also periodically cleaned up.

Viewing 1 replies (of 1 total)
  • The topic ‘Speed Optimizer is not Optimizing itself’ is closed to new replies.